Skip to content

Registered aircraft · 10,639

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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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.

N8000MBachmann Michael J · Boyertown, PABuilt 1956 · S/N 22-4054 N8001CYoung Carl J · Lubbock, TXS/N 22-2190 N8001DFaught Jeffrey R · Bismarck, NDBuilt 1957 · S/N 22-5526 N8003CNotestine Cody L · Pickerington, OHBuilt 1954 · S/N 22-2192 N8005DGibson Michael J · Gambier, OHBuilt 1957 · S/N 22-5531 N8007CManifee Doris Darlene · Black Canyon City, AZBuilt 1954 · S/N 22-2196 N800HMMakinson Aviation Warbird Restorations Inc · Deland, FLS/N 22-4168 N8011CIlfeld Richard R · Apollo Beach, FLBuilt 1954 · S/N 22-2200 N8013DMichel John Vernon III · Westminster, MDBuilt 1957 · S/N 22-5538 N8016DKeller Gary H · Washington C H, OHBuilt 1957 · S/N 22-5542 N801AAvery Walter J · Maxwell, CABuilt 1951 · S/N 22-104 N8020CThornton Jason G · El Dorado, KSS/N 22-2207 N8020DStanley Steven D · Glasgow, MTS/N 22-5545 N8021CSweet Kim · Rogers, ARBuilt 1954 · S/N 22-2208 N8021DArctic Super Pacer LLC · Anchorage, AKBuilt 1957 · S/N 22-5546 N8022CMl Aviation Consulting LLC · Zephyrhills, FLS/N 22-2209 N8022DZurovski David · Albion, NEBuilt 1957 · S/N 22-5547 N8023DSanchez Pascual G · Pantego, NCBuilt 1957 · S/N 22-5549 N8025CLaabs Fran C · Ames, IABuilt 1954 · S/N 22-2212 N8026CWyatt Gaylon J · Pineville, ARBuilt 1954 · S/N 22-2213 N8028CLisk Justin T · Rhodes, IABuilt 1954 · S/N 22-2215 N8029CFlying Zoo LLC · Collinston, UTBuilt 1954 · S/N 22-2216 N8033DLevinson Alan J · Delta Junction, AKBuilt 1957 · S/N 22-5558 N8034DMyers Mark · Clovis, NMBuilt 1957 · S/N 22-5559 N8035DSchulz Garth · Anchorage, AKBuilt 1957 · S/N 22-5560 N8037CLugten Jerry L · Leslie, MIBuilt 1954 · S/N 22-2224 N8038CFrench Christopher K · Tehachapi, CAS/N 22-2225 N8039CMatthew Karson Tyler · Lone Wolf, OKBuilt 1954 · S/N 22-2226 N8039DUllrich Sandy J · Haskell, OKS/N 22-5563 N803AWiechmann Caleb J · Prairie City, SDS/N 22-106 N8040DReboot Charity Inc · West Palm Beach, FLBuilt 1957 · S/N 22-5565 N8042DYounger Tyler J · Bakersfield, CABuilt 1957 · S/N 22-5567 N8044DGillen Sean P · Arlington, TXBuilt 1957 · S/N 22-5569 N8045CConrad Daniel R · Sweet Home, ORBuilt 1954 · S/N 22-2231 N8045DLarson Larry E · Twin Valley, MNBuilt 1957 · S/N 22-5570 N8046NSwett Frank M · Zebulon, NCS/N 22-748 N8047DMurphy Robert · Kent, WABuilt 1957 · S/N 22-5572 N8048DBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCBuilt 1954 · S/N 54-2592 N8049DFerrell Alan B · Arlington, OHBuilt 1957 · S/N 22-5573 N804PRiley Richard G Jr · New Brighton, PAS/N 18-7909135 N8050CFalley Richard T · Fairbanks, AKBuilt 1954 · S/N 18-3395 N8050DSalerno Joseph C Jr · Gettysburg, PAFirst renewal noticeBuilt 1957 · S/N 22-5574 N8051CKnutson Wayne R · Thompson, NDFirst renewal noticeS/N 183396 N8052CBoisselle Mark F · Wasilla, AKBuilt 1956 · S/N 18-4437 N8052DObowa Denis J · Fergus Falls, MNBuilt 1957 · S/N 22-5578 N8053CStrand Christian Paul · Grand Rapids, MIBuilt 1954 · S/N 18-3398 N8056CCovell Timothy N · Healy, AKBuilt 1954 · S/N 18-3404 N8057CTrenholm Michael H · Spring Branch, TXBuilt 1954 · S/N 18-3405 N8059CRichard David L · Wilton, MES/N 18-4440 N8059DLowe Richard C · Battle Creek, MIS/N 22-5582

Back to AD 99-01-05 R1