Skip to content

Registered aircraft · 17,027

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N52612Daniels Willie L II · Castle Pines, COBuilt 1977 · S/N 177RG1215 N52619Lardin William A · Thomasville, GABuilt 1977 · S/N 177RG1216 N5261FTopken William F · Fallon, NVS/N 17253375 N52634Beck Gary F · Cypress, TXBuilt 1977 · S/N 177RG1219 N52636Macdonald Russell K · Richmond Hill, GABuilt 1977 · S/N 177RG1220 N5263QZahn Jason L · Towner, NDBuilt 1965 · S/N 17253380 N52640Crawford Bill E · Hayti, MOBuilt 1977 · S/N 177RG1224 N52643Cardinalrg LLC · Ballwin, MOBuilt 1977 · S/N 177RG1225 N52647Berling David · Litchfield Park, AZBuilt 1977 · S/N 177RG1229 N5265QCohan John K · Marina, CABuilt 1972 · S/N 15073165 N52660Yancey Steven Hunter · Helenwood, TNBuilt 1977 · S/N 177RG1235 N52662Aston Stuart A · New Braunfels, TXBuilt 1977 · S/N 177RG1236 N52663Registration Pending · Cedar Key, FLRegistration pendingS/N 177RG1237 N52667Noe Daniel P · Pittsburgh, PABuilt 1977 · S/N 177RG1240 N52669F Sharp Aviation LLC · New Baltimore, MIBuilt 1977 · S/N 177RG1242 N5267FColeman Timothy James · Cornwall On Hudson, NYBuilt 1965 · S/N 17253390 N5267QGibson Aviation Services LLC · Hudson, WIBuilt 1972 · S/N 15073167 N52680Harris John Q · Tucson, AZBuilt 1977 · S/N 177RG1246 N52684Altair Advanced Industries Inc · Bellingham, WABuilt 1977 · S/N 177RG1248 N5268FVincennes University · Indianapolis, INBuilt 1965 · S/N 17253391 N52695Farley Ryan P · Cumberland, RIBuilt 1977 · S/N 177RG1251 N52696Sladko Jeffrey · Battle Ground, WABuilt 1977 · S/N 177RG1252 N5269DGeorges Aviation Services Inc · Honolulu, HIBuilt 1977 · S/N 177RG1249 N526BBBrookover James R · Hartville, OHBuilt 1977 · S/N 177RG1239 N526FRoush Heith · Cabot, ARS/N 17700932 N526MPS Brown Inc · Durant, OKBuilt 1965 · S/N 21058630 N5270QPitman Mark T · Princeton, MNBuilt 1972 · S/N 15073170 N52713Austin-Walker Aviation LLC · Waukee, IAS/N 177RG1255 N52716Brewer Wesley G · Irvine, CAS/N 177RG1256 N52719Pynn David W · Gasport, NYBuilt 1977 · S/N 177RG1257 N5271QBridges Paul J · Denton, TXBuilt 1972 · S/N 15073171 N52723Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 177RG1258 N5272EEcolift Corp · San Juan, PRS/N R1720178 N5272UAerial Surveys Inc · Conway, ARBuilt 1964 · S/N 206-0272 N5275QSkyfarmer LLC · Culleoka, TNBuilt 1972 · S/N 15073175 N52765Benson Daniel P · Lake Placid, FLBuilt 1977 · S/N 177RG1267 N5276QCarter Nolon D · Kirksville, MOBuilt 1972 · S/N 15073176 N52786Moore Roger · Jonesboro, ARBuilt 1977 · S/N 177RG1270 N5278QRegistration Pending · Madison, MSRegistration pending, canceledBuilt 1972 · S/N 15073178 N52791Gibson James W · San Antonio, TXS/N 177RG1271 N527ANDaisy Aviation LLC · Beavercreek, OHBuilt 1965 · S/N 17252779 N527BMMarc Inc · Bolton, MSS/N P2060035 N52800Jackson Royalties Inc · Brandon, MSBuilt 1977 · S/N 177RG1273 N52802Gune Abhijit P · Dublin, CABuilt 1977 · S/N 177RG1274 N52805Conover Mark D · Santa Cruz, CABuilt 1977 · S/N 177RG1275 N52814Hyduke Robert Alan · Port Matilda, PABuilt 1977 · S/N 177RG1277 N5281QHhd Aviation LLC · Hamilton, OHS/N 15073181 N52823Sloop Danny H · Rockwell, NCBuilt 1977 · S/N 177RG1279 N52825Thomas James C · Elkhorn, WIS/N 177RG1280 N52828Jacobson Marc A · Madison, WIS/N 177RG1281

Back to AD 72-03-03 R3