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.
N9823XTop Hand Inc · Laurel, MTN9824HClimb LLC · Kalispell, MTN9824JBarksdale James Alan · Florence, ALN9824LSt Pete Aviation Services LLC · Saint Petersburg, FLN9824TNeufeld Dwayne A · Coeur D Alene, IDN9824VSafety In Motion Flight Center · Puyallup, WAN98251Wings Over Texas Holdings LLC · Denton, TXN9825GKanawha Aviators LLC · Bancroft, WVN9825TLong Duane C · Baskin, LAN98264Civil Air Patrol Inc · Maxwell Afb, ALN9826ADanek Brian C · Morris, ILN98271Mastin Aviation Inc · Pasadena, MDN9827CKae Aviation LLC · Conover, WIN9827GSpencer Jeffrey · Capistrano Beach, CAN9828AMitchell Thomas H · Kennewick, WAN9828ETa Wellner Group LLC · Lake Oswego, ORN9828JIcarus Copters LLC · Lancaster, CAN9828LJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLN9828TArts Donald W · Lincoln, CAN9828XPathfinder Aero Services LLC · Sheridan, WYN9829ARoy Rodney E DBA · Grand Marais, MNN9829HWright Steven · Shelbyville, TNN9829JInflight Corp · Chaffee, MON9829MRyan Air Inc · Anchorage, AKN9829TGeske Kenneth A · Thief River Falls, MNN982SFBauermeister Matthew · Lake Tapps, WAN982SKRowe Andrew L Jr · Hope, MEN98306United States Air Force Owner · Usaf Academy, CON9830GGonzalez Nicolas · Naples, FLN9830JJohnsen Christian · Big Bear Lake, CAN9830TPoe Joshua J · Peculiar, MON9830VLeading Edge Flight Academy LLC · Bend, ORN9830XWard Todd · Corona, CAN9831GStarr David · Mount Prospect, ILN9831JHaddix Stanley D · Hagerhill, KYN98323Civil Air Patrol Inc · Maxwell Afb, ALN98326Lum Barnett K · Temple City, CAN9832JWolfe William Keith · Greenbrier, ARN9832XAlbert Bryan W · Palmer, AKN9833AKreit Kenneth Samuel · Catlett, VAN9833HMccool Air Service Inc · Mc Cool Junction, NEN9833VMartin Kendall L · Wills Point, TXN9834CN8184h LLC · Thiensville, WIN9834GNielson Douglas W · East Troy, WIN9834LCivil Air Patrol Inc · Maxwell Afb, ALN9834THulbert Douglas S · Santa Maria, CAN9834XPemberton Ryan A · Valleyford, WAN98352Civil Air Patrol Inc · Maxwell Afb, ALN98354Jin Jin Aviation LLC · Anchorage, AKN9835AMcclain Aviation LLC · Roanoke, TX
Back to AD 87-20-03 R2