AD 87-20-03 R2
Registered aircraft · 54,015
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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.
N9794MYr-Aircraft Leasing LLC · Bethel, AKN9794VCooke George C IV Trustee · Richland, WAN9794XLeingang Mark J · Olympia, WAN97956N97956 LLC · Mesa, AZN97957Jca Aviation LLC · Wentzville, MON97958Plate Jack R · Clarklake, MIN9795APatterson Roland O · Semmes, ALN9795BSilver Express Co DBA · Miami, FLNon-citizen corporation, flight hours not reportedN9795TWhite Cap Aviation LLC · Amsterdam, NYN9795VWilliams Bob L · Udall, KSN97961Rutter Matthew J · Great Falls, MTN97963Nichols Timothy · Poulsbo, WAN97968Moses Fredric P · Wayland, MAN9796VKelley Aircraft LLC · Weyers Cave, VAN9796XHulett George A · Woodland Hills, CAN97970Mcveigh Scott M · Westlake Village, CAN97971Gregory Scott L · Prescott, AZN97975Winga Aero Corp · Wilmington, DENon-citizen corporation, flight hours not reportedN9797GPowers Burton L · Anchorage, AKN9797TBasham James L · Livingston, TXN9797XDeckpro LLC · Rexburg, IDN97981Grindstaff Aircraft Leasing Inc · Crossville, TNN97984Woody George R · Clinton, ARN9798ARupert Yuri · Lillian, ALFirst renewal noticeN9798GJantz Merle Trustee · North Pole, AKN9798TRegistered aircraftN9798ZWright Air Service Inc · Fairbanks, AKN97993N97993 LLC · Middleton, MAN97995Lxs Farms LLC · El Paso, TXN97997Redline Aviation Inc · Sioux City, IAN9799ESkyhigh Trade LLC · Wilmington, DEN9799HFriehe Berend · Moses Lake, WAN9799TDeapen Jordan Derek · Clifton, TXN979JFGoodspeed Air Service LLC · Oxford, CTN979PTCappe Ivestment Group LLC · Homestead, FLN97AVCertified Aviation LLC · Dawson, GAN97BSSidewinder Services LLC · Genoa, NVN97DSWmg Aviation LLC · Ketchum, IDN97EKern County Sheriffs Department · Bakersfield, CAN97FAJalbert John E · Greenville, MEN97FCParker Cullen B · San Antonio, TXN97FRSmith Ralph E · Lyndonville, NYN97JBVieira Nunes Da Silva Raphael · Ethel, LAN97JWDorn Albert William II Trustee · Tucson, AZN97MWRudderworks Aviation LLC · Fairfax Station, VAN9800AB T Aircraft Restorations · Bellevue, WAN9800JButts James Allen · Gainesville, GAN9800THerr Garrick D · Wasilla, AKN9801ASpivey Kenneth R Jr · Vestavia, ALN9801GTriad Aviation Academy LLC · Greensboro, NC
Back to AD 87-20-03 R2