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.
N697RBAerospace Trust Management LLC Trustee · Wilmington, DEN697SUSouthern Utah University · Cedar City, UTFirst renewal noticeN697YAHorizon Flyers LLC · Kingsford, MIN6980JNulton 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, MTN6984KRjr Airdrome Inc · Dover, DEFirst renewal noticeN6984PEnglish 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, TX
Back to AD 81-18-04 R2