AD 84-10-01 R1
Registered aircraft · 20,486
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N1555DSmith Michael D · North Myrtle Beach, SCN1557FFeaga Charles C Jr · Abbot, MEN1558DBelden George B Trustee · Sonoma, CAN1559CHardee David B · Smyrna, TNN1559DDougherty Peter I · Orchard Park, NYN1559FSchrage Timothy J · Anchorage, AKN155AZCoconino County Sheriffs Office · Flagstaff, AZN155DD M C Aviation LLC · Jennings, LAN155DGJuliet Tango Flying Services LLC · Walnut Creek, CAN155DJCorder Farms Aviation LLC · Mcarthur, CAN155DVDunning Vineyards · Haines, ORN155FCState Of Florida · Tallahassee, FLN155KPGlen Stone Contruction Inc · Henderson, KYN155KTN155kt LLC · Dover, DEN155RCClark 155 LLC · Missoula, MTN1560DSasser Christopher G · Ammon, IDN1561CDoncat LLC · Shelby, MTN1563DTramontano Jeffrey M · Prosper, TXN1564CGeisert Carl E · Chandler, AZN1565CGarrett Carter L · Soldotna, AKN1565MSwiss Horizon Family Inc Trustee · Wilmington, DEN1566DMilton William H · West Glenville, NYN1566FSelhay Michael J · Anchorage, AKN1567DQualitair LLC Trustee · MichelstadtN1569DPlane Fun Inc Tr Trustee · Snellville, GAN1569USchoolcraft Carl L · West Harrison, INN156AEHolt Cory J · Santa Ynez, CAN156JMTrechak Ashley L · Shafter, CAN156MRegistered aircraftN156VBooher Daniel Ross · Humble, TXN1570DBoswell Kurt R · Renton, WAN1570UReno70 LLC · Anchorage, AKN1571DMilton William H · West Glenville, NYN1571UFavero Michael R · Sacramento, CAN15724Mcrae Roy Sean · Thorne Bay, AKN1573FSmith David J · Duluth, MNN1574DWilliams Marc A · Ridgecrest, CAN1574PSouthern Seaplane Inc · Belle Chasse, LAN1575CMeierotto Martin A · Two Rivers, AKN1575SSkyward Flying LLC · Goshen, INN1576DMock Lurita M · Anderson, INN1576MSkyline Aviation Services LLC · Miramar, FLN1577CDunn William A · Dedham, MEN1577DWilson Travis · Oswego, KSN1578CImhof Air LLC · Ferndale, WAN1579MGospel To The Nations Ministries Inc · Dayton, OHN157CPCivil Air Patrol · Maxwell Afb, ALN157FCDepartment Of Agriculture & Consummer Services · Tallahassee, FLN157HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN157LMBaughman David · Jeffersonville, IN
Back to AD 84-10-01 R1