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.
N9322DHitchcock Mark J · Scottsdale, AZN9322JZollitsch Allan P · Lancaster, NYN9322MQuebedeaux Rentals LLC · Deridder, LAN9322RNickname LLC · Scappoose, ORN9322SBrungard Thomas L · Walnut Creek, CAN9323ESchock Richard F II · Peoria, ILN9323FCouch Bill A · Palestine, TXN9323JDaissaoui Anouar · Quincy, MAN9323MMichael Siewert · Columbus, OHN9323VRoll Douglas J · Bradenton, FLN9324DRegistered aircraftN9324JAdbdelsalam Moustafa · Buena Park, CAN9324KBellew Philip H · Gadsden, ALN9324MMcdonald Glenn · Uvalde, TXN9324SBas Part Sales LLC · Greeley, CON9324VPontoni Development Corp · Athens, MIN9324WB2w Corp · Winona, MNN9325PCody William James · South Lyon, MIN9325VJaa Holdings LLC · Springfield, ILN9325WStevens Daniel · Moss Point, MSN9326DAll Seasons Aviation LLC · Laredo, TXN9326EWest Bend Air Inc · West Bend, WIN9326FLelys · Orland, CAN9326MWoods Brian S · Longview, TXN9326VSprang Bob E · Smithville, OHN9326YHand Timothy P · Osage Beach, MON9327MChristensen Seth T · Hurricane, UTN9327PKrb LLC · Rupert, IDN9328JRegistered aircraftN9328KSantoro Alexandre Jose · Mountain View, CAN9328MBeauchamp Michael · Las Vegas, NVN9328WLahm Robert E · Parish, NYN9329JBradford Earl · Fairview, MIFirst renewal noticeN9329MSreffler Christine · Ballwin, MON9329NWang Huafei · Cupertino, CAN9329PLenders Insurance Solutions Group LLC · Ozark, MON932AZN932az LLC · Miami, FLN932BJInnovets LLC · Monument, CON932BLS Lynes LLC · Wilmington, DEN932DFHertz David R · Vermillion, SDN932ECRegistration Pending · Panama City, FLRegistration pendingN932FSAviation Equipment Co LLC · Lincoln, NEN932GArcher Flight LLC · Wilmington, DEN932JMTacos On Wheels LLC · El Paso, TXN932LTAerosim Flight Academy · Sanford, FLN932PRoss Brian D · Northfield, ILN932PWWerner Thomas M · Petaluma, CAN932RTMeldrum Dallas K · Allen, TXN932RVHeddy Danny L · Petaluma, CAN932SHBuell Travis W · Harper, TX
Back to AD 87-10-06 R1