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.
N4868NWisner David · East Hampton, NYN4869DCutler Donald R · Bolivar, MON4869NBlack Hawk Brothers LLC · Lakeland, FLN486CACivil Air Patrol · Maxwell Afb, ALN486CPCivil Air Patrol · Montgomery, ALN486TCMonte D Burke · Dallas, TXN4871FFry Robert S Jr · Poplar Grove, ILN4871TApex Corporation · Stanley, NDN4872UBushwackers Leasing LLC · Calera, OKN4873DRagan Matthew T · Boulder City, NVN4873RCavu Clearing LLC · Center Harbor, NHN4873SBurke Mark S · Kindred, NDN4876DAcute Holdings LLC · Jenks, OKN4876UCottrell Seth M · Kenai, AKN4876YCarson Engineering And Manufacturing Inc · Springdale, ARN4878DCache La Poudre LLC · Fairfield Bay, ARN4878FNistler Gabriel R · Helena, MTN4878Y182b LLC · La Plata, NMN4879FCitizen Air LLC · Port Angeles, WAN4880DBernstein Timothy D · Faith, SDN4880NFront Porch Air LLC · Dalton, GAN4880UYanikoski Joseph A · Stoughton, MAN4881DBurt Compton Enterprises Inc · Marfa, TXN4881U270 W Pearl LLC · Jackson, WYN4882NCreative Strategies Inc · Proctorville, OHN4883DKingdom Air Corps · Sutton, AKN4883FStillinger David C · Cardiff By The Sea, CAN4884DGarcia Robert · Arcadia, CAN4884NCure Louie M · Granbury, TXN4885XEggleston Kevin M · Moore, OKN4886DRegistered aircraftN4886NMartin Barry W Trustee · San Diego, CAN4886USkycase Leasing LLC · Wasilla, AKN4887Carroll Daniel G · Magnolia, TXN4887DShank Lawrence · Pagosa Springs, CON4887ZJav Air Services LLC · Anchorage, AKN4888CGoflight Inc · Birmingham, MIN4888DRegistered aircraftN4888FTaktos Ltd · Corvallis, ORN488RHI F Rooks & Associates LLC · Memphis, TNN4890FSkyline Sheet Metal Inc · Troutdale, ORN4891EHerman Darrel K · Lebanon, ORN4891ZRustair Inc · Anchorage, AKN4893DMazone Robert J · Deer Park, WAN4894TBar Aviation LLC · Madison, ALN4895DMissouri Aviation Inc · Leeton, MON4895EWestern Big R Inc · Burns, ORN4895YKeating George W · Fayetteville, ARN4896DBrown Jason · Edwards, CON4896FPorter Carl S · Seymour, TX
Back to AD 84-10-01 R1