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.

N514TDDay William B · Conroe, TXBuilt 1979 · S/N 18267361 N5151EBlhh · Dixon, CABuilt 1982 · S/N 18268293 N5151QNotsa LLC · Morrison, COBuilt 1972 · S/N 21059651 N5153DFree Fall Gulf LLC · La Grange, TXBuilt 1958 · S/N 51253 N5154AA&J Air Sales Inc · San Antonio, TXS/N 21063289 N5155DPritt Joseph H · Wasilla, AKBuilt 1958 · S/N 51255 N5156ESchwankl Michael James · Wasilla, AKBuilt 1959 · S/N 50456 N5156QN5156q Inc · Elmhurst, ILFirst renewal noticeBuilt 1972 · S/N 21059656 N5156YCaprock Spraying Inc · Vega, TXBuilt 1980 · S/N 21064100 N5157DPari Gabe M · Ontario, CABuilt 1958 · S/N 51257 N5157NAms Aviation LLC · South Bend, INBuilt 1980 · S/N 18267549 N5159ADavis Nicholas R · Madera, CABuilt 1979 · S/N 21063292 N5159DFleming James Daniel · Kansas City, MOBuilt 1958 · S/N 51259 N5159NO Bleness Kevin W · Bethel, AKBuilt 1980 · S/N 18267550 N515BBQuad B Flying LLC · Mitchellville, IABuilt 1978 · S/N R18200486 N515BFDelaware Aviation LLC · Sidney, NYFirst renewal noticeBuilt 1950 · S/N 7526 N515CLProfessional Pilot Services LLC · Miami, FLS/N 18255135 N515HE2f Trade LLC · Gainesville, TXS/N 21061457 N515KPKading Air LLC · Urbandale, IABuilt 2020 · S/N 18283113 N515MBMoxie Air LLC · Winston Salem, NCBuilt 1982 · S/N 18268202 N515RTCemco Industrial Park LLC · Belen, NMBuilt 1976 · S/N 21061235 N5160DPatton Jay A · Hobbs, NMBuilt 1958 · S/N 51260 N5160TBeaver Enterprises Inc · Wilmington, DEBuilt 1981 · S/N R18201827 N5161DKnutson Wayne R · Thompson, NDBuilt 1958 · S/N 51261 N5161NLewis Justin R · Frederick, OKBuilt 1980 · S/N 18267552 N5161USkyler Aviation · San Diego, CABuilt 1964 · S/N 206-0161 N5162DRodrigues George C · Aiken, SCBuilt 1958 · S/N 51262 N5164FBarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281082 N5164NCaribbean Way Of Life Inc Trustee · Wilmington, DEBuilt 1980 · S/N 18267554 N5165DHull Terri L · Weirsdale, FLBuilt 1958 · S/N 51265 N5166EHanson Michael M · Kent, WABuilt 1959 · S/N 50466 N5166YSchmenk Brent · Frisco, TXBuilt 2002 · S/N 18281089 N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294 N5168NRidgley Kirk L · Shingle Springs, CABuilt 1980 · S/N 18267555 N5169DHomesick Angel LLC · Black Hawk, COBuilt 1958 · S/N 51269 N516CACharlie Alpha Flying Club · Sunnyvale, CABuilt 1978 · S/N 18266702 N516DMSmall Howard · West Hartford, CTS/N 18280028 N516LPSun City Aviation LLC · Davie, FLBuilt 1998 · S/N 18280179 N5170DSandford Graves M · Moberly, MOBuilt 1958 · S/N 51270 N5170NVx LLC · Melbourne, FLBuilt 1980 · S/N 18267557 N5171DFaber Elgin · Havre, MTBuilt 1958 · S/N 51271 N5171EL & D Air · Foley, ALBuilt 1982 · S/N 18268295 N5171SHalsted Holdings LLC · Yankton, SDBuilt 1980 · S/N R18201513 N5171VLisenbey Edward · Caldwell, IDS/N 21060846 N51732Imsar LLC · Springville, UTBuilt 2002 · S/N 18281088 N5173ERyznar Daniel J · Anchorage, AKBuilt 1959 · S/N 50473 N5173UKnutson Wayne R · Tioga, NDBuilt 1964 · S/N 206-0173 N5175NArkansas Bolt Co · Little Rock, ARBuilt 1980 · S/N 18267560 N5175PSbkr LLC · Greenville, PABuilt 2002 · S/N 18281155 N5176EAirplane Money Pit LLC · Rexburg, IDBuilt 1982 · S/N 18268296

Back to AD 84-10-01 R1