AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N6784DNorth Coast Helicopter Svc Inc · Napa, CAN6784FGrant James C · Valley View, TXN6784NGrundmann William B · Bradenton, FLN6784UMellen Roger B · Winston, ORN6784VN6784v LLC · Casper, WYN6784WArnold Richard J · Eagle River, AKN67852Sunrise Aviation Inc · Ormond Beach, FLN67856Heavy Metal Air LLC · Farmingdale, NYN67859Guerra Gerald T · Sandusky, OHN6786After Hours Aviation LLC · Kalispell, MTN67864Amoth Travis M · Princeton, CAN67865Laurel Highlands Aeronautical Academy · Latrobe, PAN6786JHope John W · Greeneville, TNFirst renewal noticeN6786UCowboy Perspective LLC · Comanche, TXN6787HGordon Caleb J · Waukesha, WIN6787NN6787n LLC · Hanover, NHN6787TStar Aerobatics LLC · Columbia City, INN6787USpokane Community College · Spokane, WAN6787WNewell Keith Douglas · Pahrump, NVN67888Flight Directors LLC · Fifield, WIN6788NSamples Kurtis K · Dallas, TXN6788PEast Cascades Aviation LLC · Powell Butte, ORN6788UHoughton Lawrence A · Rsm, CAN6789JBaase Robert F · Fairland, INN6789NOwnbey James L · Lubbock, TXN6789TCrosswind Aviation Of Oklahoma LLC · Stillwater, OKN678ACHabetz Kenneth B · Ragley, LAN678ATWalling Justin M · New Carlisle, OHN678BBDalton Raymond O Trustee · Nashville, TNN678BTZavadil Duane J · Sedalia, CON678DCTaylor Ronald W · Winthrop, MEN678GAmerican Roadways LLC · Missoula, MTN678GHHamilton Gilbert R · Leesburg, VAN678JLHarper Intellectual Properties LLC · Frisco, TXN678JWWhitacre John C · Brighton, IAN678KRAlbritton Randy L · Camas, WAN678KSKingsky Flight Academy LLC · Lakeland, FLN678LHChristiansen Aviation LLC · Wilmington, DEN678PJShambora William E III · Athens, OHN678PMMills Donald · Independence, MON678RGSalter Phillip G · Beaumont, TXN678RVJones Laurence · Beaufort, SCN678SLomov Veniamin · Fair Oaks, CAN678SHHeard Jesse H · Lewiston, IDN678SPFreed Bryan S · Norfolk, VAN678VRBlair Geary L · Weatherford, TXN678WSInfinity Aviation LLC · Piedmont, SDN67904Mirza Wajahat · College Station, TXN6790UFischer Jody M · Fargo, NDN6791BHassell Dan J · Ketchikan, AK
Back to AD 90-04-06 R1