Skip to content

Registered aircraft · 8,138

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:96-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:96-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:96-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:96-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:96-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:96-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.

N33318Sudweeks Will · Overton, TXS/N 28-7525172 N3331REpik Industrial LLC · Terre Haute, INBuilt 1969 · S/N 28-5661 N33321Lauher Donna · Wimberley, TXBuilt 1975 · S/N 28-7505133 N33338Graham Mark · Fort Smith, ARBuilt 1975 · S/N 28-7525174 N3333WRegistered aircraftBuilt 1967 · S/N 28-22874 N3335RJones Wesley M Jr · Hollywood, SCBuilt 1969 · S/N 28-5662 N33367Smtm Holdings Inc · Wilmington, DEBuilt 1975 · S/N 28-7505136 N33371Galle David R Trustee · Manchester, NHBuilt 1975 · S/N 28-7505137 N33378De Young Robert · Napa, CABuilt 1975 · S/N 28-7505139 N33398Hurdt Reynold A · South Saint Paul, MNBuilt 1975 · S/N 28-7505141 N333FAHobart Aviation Inc · Akron, OHBuilt 1969 · S/N 28-25666 N333NCCapital Flying Inc · Elk Grove, CABuilt 1968 · S/N 28-5118 N33432Atmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CABuilt 1975 · S/N 28-7525189 N33443Warmsley Aviation LLC · Fort Washington, MDBuilt 1975 · S/N 28-7525193 N33444Mossbarger Beverly Jo · Jamestown, OHBuilt 1975 · S/N 28-7505146 N33460Sportsman Airpark Inc · Newberg, ORBuilt 1975 · S/N 28-7505147 N33462Becker Barton C DBA · Oneill, NES/N 28-7505149 N33482Poulton Robert J · Lincoln, RIBuilt 1975 · S/N 28-7505150 N33483Blue Wings Aviation LLC · Camden, SCBuilt 1975 · S/N 28-7505151 N3348TWarhol Peter J · Peever, SDBuilt 1971 · S/N 28-7125330 N3349TStuart John R · Taylorsville, KYBuilt 1971 · S/N 28-7125463 N3350TBaxley Aviation LLC · Baxley, GABuilt 1971 · S/N 28-7125377 N33529Moon Scott R · Plover, WIBuilt 1975 · S/N 28-7505154 N33532Williams Kevin · Irvington, ALBuilt 1975 · S/N 28-7525203 N33534Two One Aviation LLC · Benton, PABuilt 1975 · S/N 28-7505155 N33545Beck Brady P · Nixon, TXBuilt 1975 · S/N 28-7525206 N33550Nutmeg Flying Club · Stratford, CTBuilt 1975 · S/N 28-7505157 N33560Sherron Jim Kemp IV · Raleigh, NCS/N 28-7525207 N33562Aiken Flyers LLC · Aiken, SCS/N 28-7525208 N33565James Harris · Helotes, TXBuilt 1975 · S/N 28-7505158 N33595N33595 Cherokee LLC · Austin, TXBuilt 1975 · S/N 28-7525211 N33636Murphy George E · Robinson, ILBuilt 1975 · S/N 28-7525213 N33641Sutton Aircraft Salvage LLC · Palmer, AKS/N 28-7505161 N33648Sadiq Ahmed · Ontario, CABuilt 1975 · S/N 28-7525219 N33655Gordon William S III · Aurora, COBuilt 1975 · S/N 28-7525220 N33661Baker Justin Robert · Red Oak, TXBuilt 1975 · S/N 28-7505163 N33666Hancock Carl M · Glendale, AZBuilt 1975 · S/N 28-7505165 N33667Aptum Aviation Inc · Hicksville, NYBuilt 1975 · S/N 28-7505166 N33674Beaulieu Marc R · Lewiston, MES/N 28-7525222 N33676Bous Harry John · Cayce, SCBuilt 1975 · S/N 28-7525224 N33679North Star Aviation Inc · Ulysses, KSFirst renewal noticeBuilt 1975 · S/N 28-7505167 N33691Wide Open Aviation LLC · Kalispell, MTBuilt 1975 · S/N 28-7525227 N33692Horn Justin L · Hearne, TXBuilt 1975 · S/N 28-7505170 N336SBPieternelle J Coffy · Beaumont, TXBuilt 1973 · S/N 28-7305489 N33715Wdc Enterprises LLC · Beaumont, TXBuilt 1975 · S/N 28-7525231 N33728Howard Andrew · Chillicothe, OHBuilt 1975 · S/N 28-7505173 N33746Lynch Ryan · Gilroy, CABuilt 1975 · S/N 28-7505175 N33755Stearns Patricia M · Pooler, GABuilt 1975 · S/N 28-7505176 N33762Wits-Sims LLC · Canal Winchester, OHS/N 28-7525235 N33764Ps Aviation Inc · Granada, MNBuilt 1975 · S/N 28-7505178

Back to AD 96-10-01 R1