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.
N9731HCreative Strategies Inc · Proctorville, OHN9731LMaine Instrument Flight · Augusta, MEN9731MHausaman Jeffrey S · Las Vegas, NVN9731UNatale Louis H · Cedar Park, TXN9731WDacy David M · Harvard, ILN9732DTouzeau Raymond V · Newberg, ORN9732HLand & Leave LLC · Helena, MTN9732JWalborn Gary D · Youngstown, OHN9732VSiguaw Robert E · Deming, WAN9732WFlying Elvis · Jacksonville, FLN9733DMcfalls Caleb Parker · York, SCN9733EHamilton Joe · Knowles, OKN9733LStock Craig A · Devon, PAN9733MJc Mooney LLC · Tallahassee, FLN9733VTyler Ronald J · Martville, NYN9733WWilson Lyndon K Sr · Ringgold, GAN9734BPreston Aviation LLC · Henderson, KYN9734JPiper Perfect LLC · Panama City, FLN9734MHaddle Eddie · Lindon, UTN9734PHornyak Ryan J · Girard, PAN9734USls Aviation LLC · Poquoson, VAN9734WNimbus Air LLC · Frankfort, ILN97358Rick Aviation Inc · Newport News, VAN9735DSkinner Timothy G · Archer, FLN9735PSprenger Mark R · Eagle River, AKN9735UFreeman George W · Wolcottville, INN9736DCamp Doug A · Starkville, MSN9736QGregory Charlie E · Blairsville, GAN9737DFolkvord Darrel L · Toston, MTN9737LSzish Michael · Mountain Top, PAN9737QSierra Tn Aviation LLC · Vonore, TNN9737VAero Equities LLC · Ventura, CAN9737WAzzurra City Tours LLC · Staten Island, NYN9738MVurlumis George A · Pocono Lake, PAN9738WBendigo Paul L · Reading, PAN9739JSullins Drew Preston · Woodstock, MDN973ABWejco Inc · Rising Star, TXN973CPTarpon Air LLC · St Pete Beach, FLN973TMAnders Andrew C · Lansdale, PAN973YLazar Matthew A · Ocala, FLN974Mulligan Shawn P · Katy, TXN9740DSchilling Michael · Nikiski, AKFirst renewal noticeN9740EWww Bellanca US LLC · Mansfield, TXN9740JSpasiano Kyle P · Camarillo, CAN9740WD14 Flight Club Inc · Manteno, ILN9741JSchulte Lance D · East Dundee, ILN9741MPeterson Bradley A · Savoy, ILN97428Right Wing Aviation LLC · Fort Wayne, INN9742BHarp Aviation LLC · Flemington, NJN9742DJones Adam J · Lucerne Valley, CA
Back to AD 87-10-06 R1