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.
N9251MFelix Eric · Oshkosh, WIN9251PSalori Aviation LLC · Centralia, MON9251SAayan Air LLC · Westfield, MAN9251WHering Lloyd L · Boulder, CON92523Durner Charles L · Lewes, DEN92525Sale Reported · Palmetto, FLSale reportedN9252HStratus Aviation LLC DBA · Vacaville, CAN9252JFlying Wrenches LLC · Cairo, NEN9252MStarfox Aero LLC · Hays, KSN9252POsipov Yuri A · Lomita, CAN9253Gorman John J III · Statesville, NCN9253CJetstream LLC · River Forest, ILN9253DHand Keith A · Anchorage, AKN9253MBlue Eagle Air LLC · Singer Island, FLN9253PConway Brandon · Springtown, TXN9253RDr Equipment LLC · Ackerly, TXN9253SKnuth Charles Allen · Avon, INN9253VChristopher Damien · Savannah, GAN92544Walther Newell A · Wasilla, AKN92548Pulliam Richard W · Henryetta, OKN9254EMoore Thomas R · North Bay, NYN9254HShipley Donald E · Alpine, TXN9254KBas Part Sales LLC · Greeley, CON9254MWhittaker Victor · Panama City Beach, FLN9254PMeyer Aviation LLC · South St Paul, MNN9254SHolmes Jeffrey T · Oxford, CTN9254VLeyden Jar LLC · Greeneville, TNN9254WVan Metre Steven · Bel Air, MDN9255BAero Partners LLC · Sioux Falls, SDN9255CD&J Aviation LLC · Apopka, FLN9255DNorstrom Hans P · Wasilla, AKN9255PSalvia Michael · Farmington Hills, MIN9256CBluegrass Aviation LLC · Clarksville, TNN9256DGonitzke Ross J · Detroit Lakes, MNN9256GGeib Gary D · Lake Tapawingo, MON9256MLone Star Magni Gyro Inc · Taylor, TXN9256VDirschka Paul · Blandford, MAN9256XBird Acquisition LLC DBA · Phoenix, AZN92570Becker Steven H · Prescott, AZN92576Oman Ronald G · Chugiak, AKN9257CAcorn Aviation LLC · Saint Charles, ILN9257HTaf Aerial Services LLC · Beeville, TXN9257JWojtecki Chris R · Florissant, CON9257MMouser Ryan D · Paragould, ARN9257NJohn Bowman Inc · Fountain, CON9257PBrooks Laura · Palmer, AKN9257VKelley Gaylord L Jr · Murrells Inlet, SCN9258CBack Forty Flying Club Inc · Roanoke, INN9258DFlansburg Robert D · Middletown, DEN9258JHummingbird Avaition LLC · Columbus, IN
Back to AD 87-10-06 R1