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.
N9338BTopp Jason · Grace City, NDN9338EComanche Hills Aircraft LLC · Lampasas, TXN9338HSchab Davis Maragaret A · Spangle, WAN9338RMeshinsky Jeffrey · Alpine, CAN9338XHathaway David P · Waterbury, VTN9338ZBarr Air Patrol LLC · Mesquite, TXN93397Jet & Rotor Aviation LLC · Sacramento, CAN9339ASwede Aviation LLC · Tucson, AZN9339XSedona Aviation LLC · Sedona, AZN933AZN933az LLC · Miami, FLN933DB933db LLC · St Louis Park, MNN933DDHarris John Alfred · Havana, FLN933PAerowood Aviation LLC · Monroe, NCN933SASunrise Aviation Inc · Ormond Beach, FLN93407Board Of Trustees DBA · Murphysboro, ILFirst renewal noticeN9340BCook Raymond L · Spring Grove, ILN9340CWolfe Donald E · T Or C, NMN9340UJohnson Cory D · Rugby, NDN9341ARollison James · Scottsdale, AZN9341BYager Keith E · Eugene, ORN9341HAndreas Neil A · Yakima, WAN9341XKent Steven P · Warwick, NYN9342GBaumann James J · Trabuco Canyon, CAN9342HGutierrez Ricardo · Downey, CAN9342RCampbell Gene H · Baytown, TXN93434Silver Express Co DBA · Miami, FLN9343BBas Part Sales LLC · Greeley, CON9343DAva Aviation LLC · Tappan, NYN9343GOlivo Investments Group LLC · Richmond, TXN9343TJansen Guy A · Lynden, WAN9343ULazor Ronald E · Middlefield, CTN9343XYoung Charles T · Los Banos, CAN93444Sullivan Wayne · Rockport, TXN9344BSumners David O Jr · Eastville, VAN9344CPage James S · Avoca, TXN9344HBarnstormers Flying Club Inc · Pulaski, TNN9344LCivil Air Patrol Inc · Maxwell Afb, ALN9344UNewman Thomas E · Saint Ignatius, MTN93454Marsh John E · Washington, DCN9345BPasquariello Thomas · Alton, NHN9345CBunting Gordon E · Bend, ORN9345GFrederick Paul M · Tucson, AZN9345LHaynie Aviation LLC · Alexander City, ALN9345XBordner Christopher P · Santa Cruz, CAN93468Bestway Transport LLC · Raymond, NEN9346AWilliams Darrell W · Fayetteville, ARN9346BHarter Wayne R Jr · Alliance, OHN9346DHolloway James H · Merritt Island, FLN9347GNazir Donna Lacruz · Boca Raton, FLN9347HWings Like Eagles LLC · Wilmington, DE
Back to AD 87-20-03 R2