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.
N93CMekolichick Jerry D · Whitehall, PAN93CDDe Leon Jonas · New York, NYN93CFSink Abram T · Hillsboro, OHN93DASeptember Bravo Enterprises LLC · West Olive, MIN93DECore Peak Consulting LLC · Moorcroft, WYN93DNRiseaero LLC · Florence, SCN93DSSrofe Danny D Jr · West Portsmouth, OHN93DTTolkach Dennis · Dunlevy, PAN93EREdal Inc · Plantation, FLN93FFPeauy Mike J · Chico, CAN93GFRanieri Realdo · Mesa, AZN93GGGosser Chad K · Russell Springs, KYN93GMPrice Justin E · Charlotte, NCN93GPHorizon Helicopters Inc · Newark, DEN93GWRegistration Pending · Glenn, CARegistration pendingN93HBVranes Michael · Zephyr Cove, NVN93HUFugleberg Lance R · Portland, NDN93HYBorrego Farms Inc · Valley Center, CAN93JSNeptune Aviation Services Inc DBA · Missoula, MTN93KCT I M E Flight Inc · Heber Springs, ARN93KKMonmouth Area Flying Club · Lakewood, NJN93KNPataky Gabriel J · Sarasota, FLN93LDMcnabb Ernest Mark · Somerville, TNN93LRSuchomel Charles F · New Carlisle, OHN93MCGabel Allan · Oxnard, CAN93MGCastle Aviation Inc · North Canton, OHN93MLAsher Kevin C · Wasilla, AKN93MVWell Bilt Industries USA LLC · Ocala, FLN93MYReuterskiold Jerold L · Friendship, WIN93PNHawkins Steven L · Grand Prairie, TXN93RFRegistered aircraftN93RJStamm David · Lake Almanor, CAN93RPShafer Andrew · Phoenix, AZN93RRReid Ronald T · Oxnard, CAN93RSJones Warwick L · Torrance, CAN93RVMouliere Billy D · New Waverly, TXN93SAOverbey Shane · Detroit, MIN93SKHall William N Jr · Cocoa Beach, FLN93SMVilla Aviation LLC · Alpharetta, GAN93TBWarmkessel James R · Felton, CAN93TEOlwell Cheryl · Bulverde, TXN93TJSale Reported · Crystal, MNSale reportedN93UGBellas Business LLC · Kalispell, MTN93VBSky Blue Inc · Wilmington, DEN93VSLmh Industries Inc · Long Beach, CAN93WEBoeing Employees Flying Assoc · Renton, WAN93WKPiercy Ronald S · Moses Lake, WAN93WPHbfc Inc · Tehachapi, CAN93WRDukic Slobodan · Jacksonville, FLN94000Champion Aircraft LLC · Valdosta, GA
Back to AD 87-10-06 R1