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.
N9233WMount Up Aviation LLC · Kirbyville, MON9233ZCalmwinds LLC · Middletown, DEN9234ACruz Salvador A · Sumter, SCN9234ELdg LLC · Kalispell, MTN9234KUnusual Attitudes LLC · Stow, OHN9234MRed Tail Scholarship Foundation · Tuskegee, ALN9234WRutledge Brent E · Uvalde, TXN9234ZIovanna Steven · Plymouth, MAN92356Hub City Aviation Academy LLC · Lubbock, TXN9235CWilliams Patrick S · Saint Paul, MNN9235PJen Lyn Inc · Wilmington, DEFirst renewal noticeN9235QInternational Air Services Inc Trustee · Carson City, NVN9235SKaidor Jerome L · Hayward, CAN9235VLott William F Jr Trustee · Oklahoma City, OKN9235YKamasano LLC · Highland, CAN92362Yeakley Gary G · Ontario, CAN9236CRudloff Uwe K · Lake Village, INN9236EPorch Brock J · Philip, SDN9236HOptic Air LLC · Sioux Center, IAN9236JThunderbird Air LLC · Grand Rapids, MIN9236KLabrada Fabio · Decatur, TXN9236NWilliams Robert J · Sewickley, PAN9236PTasso Aviation LLC · Orrville, ALN9236SMahi Aviation Corp · Winter Garden, FLNon-citizen corporation, flight hours not reportedN9236VYeske Brock Ray · Peoria, ILN9236WSchmidt Robert · Winchester, WIN9236YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN9237JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN9237PCloud Climibers LLC · Lexington, KYN9237VPortouw Lawrence J · Huachuca City, AZN9237WDoyle Michael J II · Wakeman, OHN9238Cronite Global Corp · Parsippany, NJN9238KCrow Wing Flying Club Corp · Nisswa, MNFirst renewal noticeN9238NBloomberg David C · Northampton, MAN9238PPylant Eric Jon · Arnold, CAN9238RBruce Ronald · Momence, ILN9238SAllt International LLC · Parker, CON9238WMansour Muhamad A · Wichita, KSN92390Elek LLC · Springfield, MON9239DMisson Aviation LLC · Lima, OHN9239JAshmore Benjamin H Jr · Austin, TXN9239NRd Aviation LLC · Fort Lauderdale, FLN9239SRoyer Richard W · Winnebago, MNN9239VRegistration Pending · Louisville, MSRegistration pendingN9239WBenrud Jeffrey S · Raeford, NCN9239YDelgado John F · San Antonio, TXN923ACWarnock Tony J · Mobile, ALN923AMEdburg Stanley L · Mead, WAN923DBGrenville Andrew · Decatur Island, WAN923DMHt Holdings LLC · Oxford, MS
Back to AD 87-10-06 R1