AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N7698JMetz Mark A · Ida, MIN7698PJohn Tom · Las Vegas, NVN7698WFlyhnz LLC · Oxford, NCN76990Brown Hector M · Glenwood Springs, CON7699GZhao He · Yaphank, NYN7699JHamilton John B · Stafford, VAN769AMeridian Aircraft LLC · Wilmington, DEN769AKThomas Cole A · Fairbanks, AKN769ATTarragon Aircraft USA LLC · Pekin, ILN769CERogers Charles M · Pilot Hill, CAN769CPCivil Air Patrol · Maxwell Afb, ALN769FGMustang Sally Aviation LLC · Camden, SCN769GALong Island Aviators LLC · Seaford, NYN769GMN373hp LLC · Ladera Ranch, CAN769JBGibson Randy L · Clinton, TNN769NDN769nd LLC · Sidney, MTN769NERegistration Pending · Pottstown, PARegistration pendingN769RAMcclure Dennis N · Mcalpin, FLN769RVWinston James R · Cornelius, NCN76ADWerner Richard · Syosset, NYN76AHOrthoplane LLC · Kalamazoo, MIN76AMRosinbaum Daryl A · Waller, TXN76ATCarney Raymond L · Newton, ALN76AUHayes Michael Mckool · Destin, FLN76BCYackley Ranches · Onida, SDN76BDAndersen Diane M · Palm City, FLN76BKMohler Tucker A · Sautee Nacoochee, GAN76CMRegistration Pending · New Braunfels, TXRegistration pendingN76CRTownsend Joseph A · Buckeye, AZN76DHKarapelou James M · Allentown, PAN76DMHendrix Aviation Inc · Plantation, FLN76DRAppleget Edward L · Glendale, AZN76DSDeemer Jerry C · Granbury, TXN76DUL&P Of Mke LLC · Milwaukee, WIN76DVTuchscherer William G · Oshkosh, WIN76EVKuhn Bernard O · Ripon, CAN76FCBlackhawk Holding Corp · Wilmington, DEN76FFFf22 LLC · Scottsdale, AZN76FKSmith Fleet K IV · Stephens City, VAN76GCEdgerton Richard T · Arlington, WAN76GDCoulter Dennis W · Lincoln, CAN76GLSullivan Vincent E · Centerville, IAN76GZLankford Philip S · San Marcos, CAN76HBSinger Michael · Mission Viejo, CAN76HJAmalong Timothy M · Tucson, AZN76HKDodson International Parks Inc · Rantoul, KSN76HRHeadwaters Flying Service LLC · Three Forks, MTN76HSDelgrosso Dennis W · Saranac, NYN76HYCarley Dale H · Griffin, GAN76JAJahawk Leasing LLC · Sugar Grove, IL
Back to AD 81-18-04 R2