AD 87-20-03 R2
Registered aircraft · 54,015
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-20-03-R2')
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-20-03-R2')
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-20-03-R2') 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-20-03-R2') 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.
N91CCDeep Creek Aviation LLC · Ashburn, GAN91DAJav Air Services LLC · Anchorage, AKN91DJNola Knewbees LLC · New Orleans, LAN91DMHead Joseph A · Fairbanks, AKN91GEGas Aviation LLC · Decatur, TNN91HLWisconsin Aviation-Four Lakes Inc · Madison, WIN91LPDreisewerd William · Winfield, MON91LVWoodfield Terry J · Pearland, TXN91MWSub C Air LLC · Spring, TXN91PAHigh Wing Air LLC · Arnold, MON91PCChay Dan B · Kenai, AKN91PHJulien John · Houghton, MIN91PMRunrich LLC · Newport News, VAN91QSFly Diablo Inc · North Wales, PAN91RBlack Pilots Of America Detroit Chapter · Detroit, MIN91WAStevens James L · Carrollton, GAN92000Clift Robert E · Anchorage, AKN92006Troughton Jill A · Spring Hill, FLN92009Will Dennis L · Clyde, MIN9200CShepard Philip A · Trophy Club, TXN9200GNoya Charles J · Albuquerque, NMN9200UCherry Hill Aviation Inc · Freetown, INN9200XCochreham Bryce O · Seibert, CON92013Burns Dale E · Kamiah, IDN92014Shotwell Land Management Co LLC · Jackson, MSN92016Campbell Kevin T · Gretna, NEFirst renewal noticeN92018Mercenary Medical LLC · St George, UTN9201HSparkwizard LLC · Greenville, RIN92020Domaille Dennis C · Mammoth Lakes, CAN92021Pisiak Sonny S · Queen Creek, AZN92026Haltom Frances F · Alva, OKN9202AWilson Alan Trustee · Waukesha, WIN9202TLander David W · Gilroy, CAN9202XNohrenberg Larry R · Jamestown, NDN92035Ford Daniel T · Warsaw, INN92039Newwing LLC · Freeland, WAN9203CSamuel James F · Port Byron, NYN9203GStohr Jeffry M · Aberdeen, SDN9203TMartinson Douglas E · Nome, AKN9203UAlaskan Mariners Inc · Homer, AKN9203XPeru Projects Inc · Lincoln, NEN92049Put Ronald · Alameda, CAN9204AConrad William A · Kaukauna, WIN9204BMcelwain Floyd · Saint Joseph, MON9204GSchwend Brian · Forsyth, MTN9204HTongass Air LLC · Ketchikan, AKN9204TDoner Daniel D · Highlands Ranch, CON92050Tysky Air LLC · Arvada, CON92051Yardy Paul J · Caledon OntarioN92054Waterheat Inc · Anchorage, AK
Back to AD 87-20-03 R2