AD 87-10-06 R1
Registered aircraft · 72,010
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-10-06-R1')
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-10-06-R1')
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-10-06-R1') 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-10-06-R1') 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.
N6980JNulton Enterprises LLC · Johnstown, PAN6980QHulme Aviation LLC · Gilbert, AZN6980RRock Your Wings LLC · Litchfield, OHN6980UHarvard Air Taxi LLC · Andover, MAN6980VTenney Kenneth Lee Jr · Princeton, KYN6981BTownsend Monte A · Wasilla, AKN6981HAll2fly LLC · Atlanta, GAN6981PShakis Bear LLC · O Neill, NEN6981WHammontree David M · Rickman, TNN6982FSale Reported · Palm Coast, FLSale reportedN6982PCapuano Group Inc · Ormond Beach, FLN6982UStanley Harrelson Mccall · Pepperell, MAN6982VTwardowski Przemyslaw · Pasadena, CAN6982WMoran Erick A · Orange, CAN6982ZButler Marine Aviation Inc · Alexandria, VAN6983BWiltz Paul E · Opelousas, LAN6983DGoebel William R · Rhome, TXN6983EBurkhardt Charles P Jr · Norco, CAN6983HWaddell Pap LLC · Friendswood, TXN6983JLaid Back Investment Holdings LLC · Cairo, GAN6983PRegistration Pending · Branchburg, NJRegistration pendingN6983WTuttle James M · Newell, IAN6984BBig Q Aviation Corp · Helena, MTN6984PEnglish John H · Pittsburg, TXN6984VEitzmann Bryce J · Clinton, ARN6985DRegistration Pending · East Gull Lake, MNRegistration pendingN6985PDull Stephen A · Redkey, INN6985QOneal Joseph M · Mariposa, CAN6985RWard Chad E · Paducah, KYN6986QBennett Donald M · Burley, WAFirst renewal noticeN6986UNabors Ricky D · Valrico, FLN6987BState Of Alaska · Kodiak, AKN6987DBorror Bryce C · Gerber, CAN6987J3 November 6 LLC · Old Bridge, NJN6987QSmith Casey W · Houlka, MSN6987ZWilliams Mark · Cumming, GAN6988JDamon Paul H · Brigham City, UTN6988PKubitz Wesley M · Laurel, MTN6988UKisthard James A · Roberts, MTN6988VGreenlee Matthew Steven · Arnold, CAN6988WLowe-Wing Aviation Inc · Wilmington, DEN6989BHolzman Douglas S · White Salmon, WAN6989QHumphrey Bobby E · Dandridge, TNN6989RMoran Dennis E · Waverly, PAN6989VFussell James Vaulx V · Jackson, MSN6989WCarter Johnny W · Crawford, TXN698CACommander 1 Flight Group LLC · Wilmington, DEN698CHFranklin Ricky L · Glade Hill, VAN698CPSerodind Peterj · Chattanooga, TNN698FLNight Fox Aircraft LLC · Mesa, AZ
Back to AD 87-10-06 R1