AD 84-10-01 R1
Registered aircraft · 20,481
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.
N5107DHardman Lorin D · Wasilla, AKN5107EMixon Dennis E · Topsham, MEN5108DTeam Gateway LLC · Lewes, DEN5108NBerry Lisa A · Yuba City, CAN5108QPardue William C Jr · Leesville, LAN5109DCaine Jennifer M · Rigby, IDN5109QRmcb LLC · Kalispell, MTN510AASky West Aviation Inc Trustee · Albuquerque, NMN510ARBrudigam Norman · Lafayette, CAN510ECState Of Tennessee Department Of Transportation · Nashville, TNN510FMckeen Charles Dale · Howard Lake, MNN510KSNational Aircraft Leasing Corp · Greenville, DEN510SLBeery Roofing & Redesign LLC · Deland, FLN510TRAltamira Flying Club Inc · Round Rock, TXN510WFFuel Center Plus Inc · Silver City, NMN5110DBlaine Wright Inc · Polson, MTN5110EHartley Kirk R · Palmer, AKN5110UGiese Shari L · Wasilla, AKN5111GHammond Jason · Nevada City, CAN5112DScootair LLC · Alburgh, VTN5112ETail Wheel Excursion LLC · Redmond, ORN5112GCrawford Law Pllc · Selah, WAN5112NRcr Aviation LLC · Cave Creek, AZN5114DCasillas Justin M · Liberty, TXN5114EVinton John H · Mullen, NEN5114QJ&A Air · Richfield, UTN5115NFernandez Arriaga Emilio · Miami, FLN5116DRoche Patrick R · Wichita Falls, TXN5117DAndre Kashierski · Estill Springs, TNN51198Registered aircraftN5119UClark Christopher F · Boise, IDN5119XMission Aviation Fellowship · Nampa, IDN5119YWby Aviation LLC · Lewes, DEN511CWSydow Daniel P · Duluth, MNN511DCJago River Holdings LLC · Fairbanks, AKN511DWD.B. Wood LLC · Levering, MIN511MHZeringue Amanda E · Southern Pines, NCN511PMD & J Air Adventures Inc · Koloa, HIFirst renewal noticeN511RLHatch Leasing Co LLC · Marble Canyon, AZN511WValdez Ricardo · Midlothian, TXN5120VTreaster Implement Co Inc · Beloit, KSN5120XZimmerman Tom V · North Pole, AKN5122EMertesdorf John P · Nicollet, MNN5122NMeyer Ricky · New Liberty, IAN5122QPyxis LLC · Cheyenne, WYN51237Infanger James Robert · Salmon, IDN5124NSolomon Dennis R · Odessa, FLN5125E18aa Meadows LLC · Haines, AKN5125NNorris Marvin D · Georgetown, TXN5126DDalrymple Mike B · Salinas, CA
Back to AD 84-10-01 R1