Skip to content

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

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

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.

N7422QZimmer Steven F · Lacrosse, WABuilt 1972 · S/N 18261062 N7422XMacvey Troy R · Milan, INBuilt 1949 · S/N 7422 N7423NHolland Reggie K · Dillsboro, INBuilt 1974 · S/N 18263201 N7425EYoung James Steele · San Diego, CABuilt 1960 · S/N 57125 N7425NSteiner Stephen Trustee · Redding, CABuilt 1974 · S/N 18263203 N7427QDavidson William F · Port Orange, FLBuilt 1972 · S/N 18261067 N7428NHawthorn Transportation LLC · North Sioux City, SDBuilt 1974 · S/N 18263206 N7429NWholly Guacamole LLC · Steamboat Springs, COBuilt 1974 · S/N 18263207 N742CPCivil Air Patrol · Naxwell Afb, ALBuilt 2006 · S/N 18281799 N742DC5c Aviation Inc · Boise City, OKBuilt 1974 · S/N 18262821 N7430EBallesteros Irlena · Glendale, CAS/N 57130 N7430QFlying Paws Aviation LLC · Louisville, COBuilt 1972 · S/N 18261070 N7431EGeyer Austin D · Minot, NDS/N 57131 N7431NWe Fly LLC · Fort Payne, ALBuilt 1974 · S/N 18263209 N7432NJensen David F · Clarks Grove, MNBuilt 1974 · S/N 18263210 N7432QWatkins Daniel L · Fuquay Varina, NCBuilt 1972 · S/N 18261072 N7432SAnderson Jeffery G · Calhoun, LABuilt 1976 · S/N 18265194 N7433NFixed Gear LLC · Sherwood, ARBuilt 1977 · S/N U20603660 N7434QD'Ambrosia Louis E · Chardon, OHBuilt 1972 · S/N 18261074 N7435NPieretti George L · Sacramento, CABuilt 1974 · S/N 18263213 N7436EFreedom Airforce · Albuquerque, NMBuilt 1960 · S/N 57136 N7436QStefanowicz Chester J · Baltimore, MDBuilt 1972 · S/N 18261076 N7437NSundance Aero LLC · Mertzon, TXBuilt 1974 · S/N 18263215 N7438EWalker Jim O · Lovell, WYBuilt 1960 · S/N 57138 N7438NMockler Sarah Margaret · Awendaw, SCBuilt 1974 · S/N 18263216 N7439QSpoer Jonathan M · Agoura Hills, CABuilt 1972 · S/N 18261079 N743CPCivil Air Patrol · Naxwell Afb, ALBuilt 2006 · S/N 18281800 N743HLanoue Edgar A · Stevensville, MTBuilt 1969 · S/N U206-1297 N743KSBarrett Buford L · Bristol, VABuilt 1976 · S/N 18052710 N7440EWilson Colton M · Wellsville, UTS/N 57140 N7440NDrewes Farms Inc · Craig, MOS/N 18263218 N7440QAircraft Holding LLC · Orem, UTBuilt 1972 · S/N 18261080 N7441NAir Impressions Inc · Waco, TXBuilt 1974 · S/N 18263219 N7441QRegistered aircraftRegistration pendingBuilt 1972 · S/N 18261081 N7444QGroffman Armand Rossini · Los Alamos, NMBuilt 1972 · S/N 18261084 N7445EElite Aircraft Sales LLC · Searcy, ARFirst renewal noticeS/N 57145 N7445NSkyplane Pilots LLC · Bluffton, SCS/N 18263223 N7445QPennino James B · Rancho Cucamonga, CABuilt 1972 · S/N 18261085 N7446QAvco Patrol LLC · Lyndon, KSBuilt 1972 · S/N 18261086 N7448NCcx-2000-0111 LLC · Garberville, CABuilt 1977 · S/N U20603662 N7448QWilkus Michael J · Mound, MNBuilt 1972 · S/N 18261088 N7449EDabir-Ebrahimi Mike M · San Mateo, CABuilt 1960 · S/N 57149 N744CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281803 N744DPAviation Components Inc · Tarzana, CABuilt 1968 · S/N 18258929 N744EFTango Alpha Sierra LLC · Austin, TXBuilt 1976 · S/N 18264796 N744HRStefan William C · Lockwood, MOS/N R18201626 N744NGEvans William H Jr · Gardendale, TXBuilt 1953 · S/N 30397 N744RCastaneda Jose · Yakima, WABuilt 1974 · S/N 21060521 N744WTwin Bridges Aviation LLC · Sheridan, MTS/N 33701 N7450EFernald Greg · New River, AZBuilt 1960 · S/N 57150

Back to AD 84-10-01 R1