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.
N6305BLeggett Bryce · Eola, TXN6305FGianquinto Joseph J Trustee · Bakersfield, CAN6305UMission Aviation Fellowship · Nampa, IDN6306BGmr Leasing LLC · Lincoln, DEN6306CLongs Air Conditioning Inc · Avon Park, FLN6308ABravo Hotel LLC · Lewes, DEFirst renewal noticeN6308BSnyder Kenneth Clayton · Lonsdale, MNN6308HAmerican Aviation Inc · Page, AZN6309BDz Aviation LLC · Nephi, UTN630ATAir Tiger LLC · Eunice, LAN6310BWilliams Clayton S · Mason, NHN6312AJosephine Air LLC · Castle Rock, WAN6312BUsda Forest Service Fepp · Helena, MTN63130Box Talon · Cotulla, TXN6313BLashbrooke Dana F · Durango, CON63145Morin James R · West Ossipee, NHN6314AGarletts Frank · Jackson, MSN6314BGregg Delvin K · Durango, CON6314CC4p LLC · Jackson, TNFirst renewal noticeN6314DSaghafi Jamsheed Trustee · Parma, OHN6315APerkins Larry L · Wildomar, CAN6315BEbright Sean E · Hasty, CON63166Chucks Aircraft LLC · Hartland, MEN6318AElliott Dave P · Boulder, CON6318BCenturion Associates 2 LLC · Elgin, SCN6319BAtarah LLC · Tucson, AZN6319FAbidance Inc · Winthrop, WAN6319TSunland Aviation LLC · Swansboro, NCN631AFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN631CPCivil Air Patrol · Maxwell Afb, ALN631SLee Grant L · Dallas, TXN6320HWaypoint Corp · Clearwater, FLN6321FSolar Repair Center Inc · Beaumont, CAN6321HBluebird Inn Inc · Fish Haven, IDN6321TTwo One Tango LLC · Waynesboro, PAN6322FKamp LLC · Kalispell, MTN6323AGlick Brady M · Colorado Springs, CON6323BJennett Cheryl K · Phoenix, AZN63242Douglas Dustin D · Tea, SDN6324ADiaz Anthony V · Salinas, CAN6325APrestegard Michael L · Delta Junction, AKN63267W A Redgate · Crescent Valley, NVN6326ANipper Melanie T · Defuniak Springs, FLN63275Qualitair LLC Trustee · MichelstadtN6327ASmith Mathias N · Weiser, IDN6327BNilsen Kim W · Hailey, IDN6328AHsd&R Enterprises Inc · Abilene, TXN6328CArnold Aviation & Thunder Mountain Express Inc · Cascade, IDN6328YKoehn Lacey · Van Horn, TXN6329AAlpine Medical Services Inc · Hayden, ID
Back to AD 84-10-01 R1