Skip to content

Registered aircraft · 1,310

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:94-18-04-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:94-18-04-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:94-18-04-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:94-18-04-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:94-18-04-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:94-18-04-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.

N94129Westall Melina Joan · Anchorage, AKBuilt 1946 · S/N 1452 N94131Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1454 N94134Hahola James J · Easton, PABuilt 1946 · S/N 1457 N94135Flying Wrenches · Buhl, IDBuilt 1946 · S/N 1458 N94145Smith Dwight S · Ann Arbor, MIBuilt 1946 · S/N 1468 N94160Registration Pending · Waldo, OHRegistration pendingBuilt 1946 · S/N 1483 N94171Tittle James L · Pembine, WIBuilt 1946 · S/N 1494 N94175Preslicka Eric · York, NEBuilt 1946 · S/N 1498 N94188Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1511 N94189Champion James D · Urbandale, IABuilt 1946 · S/N 1512 N94191Olson Daren C · Tichnor, ARBuilt 1946 · S/N 1514 N94193Washington Buddy K · Ten Sleep, WYBuilt 1946 · S/N 1516 N94195Photakis Gary B · Kirkland, WABuilt 1946 · S/N 1518 N94307Bellings Eric E · Neshkoro, WIBuilt 1946 · S/N 1530 N94308Hoyer Brian Lee · Wickenburg, AZBuilt 1946 · S/N 1531 N94311Broadwell Eric · Woodstock, GAS/N 1534 N94315Whitmire Joseph A · Soddy Daisy, TNBuilt 1946 · S/N 1538 N94316Nowicki John W · West Chicago, ILBuilt 1946 · S/N 1539 N94320Gap Aircrafts LLC · Dover, DEBuilt 1946 · S/N 1543 N94333Hodgson John S · Genoa, NVBuilt 1946 · S/N 1556 N94342Sale Reported · Crystal, MNSale reportedBuilt 1946 · S/N 1565 N94348Devlin Robert E · Hillsborough, NJBuilt 1946 · S/N 1571 N94351Daffer Jon Terrill · Edgewood, NMBuilt 1946 · S/N 1574 N94354Hertel Jane V · Granbury, TXBuilt 1946 · S/N 1577 N94355Cato James W · Las Cruces, NMBuilt 1947 · S/N 1578 N94357Ratzlaff James P · Newton, KSBuilt 1946 · S/N 1580 N94365Logemann Dennis F · Sandia, TXBuilt 1946 · S/N 1588 N94366Hepner Glenn L · New Port Richey, FLBuilt 1946 · S/N 1589 N94367Flying L Aircraft Inc · Fort Denaud, FLBuilt 1946 · S/N 1590 N94372Johnson Randal D · Clearwater, FLBuilt 1946 · S/N 1595 N94376Kimberly Charles M · Wellington, FLBuilt 1946 · S/N 1599 N94390Hershorin Paul A · Okeechobee, FLFirst renewal noticeBuilt 1946 · S/N 1613 N94398Bores Scott J · Huron, OHS/N 1621 N94403Mcgee Danny P · S Prince Geo, VABuilt 1949 · S/N 5035 N94411Sale Reported · Evansville, INSale reportedBuilt 1950 · S/N 5069 N94418Gregory Vernon L · Swansea, SCBuilt 1950 · S/N 5047 N94423Marshall Jerry D · Hachita, NMBuilt 1946 · S/N 2978 N94426Battie Kenneth L · Seattle, WAS/N 5060 N94427Ericson Eric · St Charles, ILS/N 5073 N94428Ross William P · Brighton, MIBuilt 1950 · S/N 5074 N94431Byrne Matthew A · West Allis, WIBuilt 1950 · S/N 5077 N94438Gassert Kevin J · Cincinnati, OHS/N 5008 N94621Specht Leo M · Towner, COFirst renewal noticeBuilt 1947 · S/N 4722 N94625Costilow Bobby W · Griffin, GABuilt 1947 · S/N 4726 N94633Hawkins Paul R · Peachtree City, GABuilt 1947 · S/N 4740 N94636Gregory Vernon L · Swansea, SCBuilt 1947 · S/N 4743 N94641Grizzard John Matthew · Newport News, VABuilt 1948 · S/N 4748 N94654Moose James E Jr · Newton, NCBuilt 1947 · S/N 4763 N94656Stevens Charles L · Casa Grande, AZBuilt 1947 · S/N 4766 N94667Alee-Jay Enterprises Inc · Topeka, KSBuilt 1947 · S/N 4778

Back to AD 94-18-04 R1