AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N17033Browning Brad T · Lake Park, MNN17039Davidson Luke H · Gilmer, TXN1703NEvans Richard H Sr · Holt, FLFirst renewal noticeN1703QTroutman Noah M · Owensboro, KYN17043Coleman Sherod · Houston, TXN17045Streichenwein Scott F · Salisbury Mills, NYN17047Sickinger Alan W · New Philadelphia, OHN17048Myob Group LLC · Ocala, FLN1704DSykes Gregory P · Arlington, WAN17053Rough Joseph W · Priest Lake, IDN1705DSchultz Jeffrey J · Wasilla, AKN1705FTennis Gayland L · Bath, MIN17060Jacobsen Lee E · Inchelium, WAN17065Glaser Donald L Jr · Olive Branch, MSN17069Joyce Michael P · New Kent, VAN1706DMaser Matt P · Junction City, ORN1706VHermann Christine F · Radford, VAN17077Shehl George William III · Charleston, WVN1707DMorse David M · Kernersville, NCN1707FFreije Anthony M · Anchorage, AKN1707QGarcia Jorge A · Ponce, PRN1708FKnudsen Mark A · Whitmore Lake, MIN1708QJergovich Jack A · Austin, TXN1708UShelton Philip C · Wise, VAN1708VMock Paul M · Williams, AZN17098Lake Michigan Asset Management LLC · Grand Rapids, MIN170AGHuber David C · Victoria, TXN170AKPerry John E · Kenai, AKN170ARSmith Edward T · Bradenton, FLN170ASBowe Rick J Trustee · Chippewa Falls, WIN170ATVan Anda Aviation LLC · Apopka, FLN170BRegistered aircraftN170BBSmothers Joey D · Dwight, ILN170BGFinley Rory P · Loon Lake, WAN170BKDugan Robert J · Boulder City, NVN170BSMcintyre James C · Bethlehem, PAN170BTSparks Richard M · Wasilla, AKN170CFAbes Erika · El Paso, TXN170CLHickle William H · Inyokern, CAN170CPLawrence Wyatt · White House, TNN170CWHohmann Courtney P · Jacksonville, FLN170DFWilliams John S · Cleveland, TXN170DMBarnstorm/T-34 LLC · Jacksonville, FLN170DPLeingang Mark J · Olympia, WAN170DWBelden George B · Sonoma, CAN170ECMueller Brent · Saint Maries, IDN170EEDowd Darin R · Gainesville, TXN170ERBowles Brent J · Iraan, TXN170ETPalmatier Harry C III · Volant, PAN170FMMain Freddie L II · Trophy Club, TX
Back to AD 94-05-05 R1