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.

N46709Cloud Dancer Aviation Inc · Deland, FLBuilt 1968 · S/N 17257443 N46713Lochner Richard A · Eagle River, AKBuilt 1968 · S/N 17257446 N46715Dillingham Robert S · Soldotna, AKBuilt 1968 · S/N 17257447 N46718Webster Steven · Stroudsburg, PABuilt 1968 · S/N 17257449 N46719Cabrera Ramon F · Guttenberg, NJBuilt 1968 · S/N 17257450 N4671LCraft William J · New Baltimore, MIBuilt 1966 · S/N 17254666 N46720Grover Gary R · Grand Marais, MNBuilt 1968 · S/N 17257451 N46721Bristol Robert W · Sandpoint, IDBuilt 1968 · S/N 17257452 N46722Tingey Brent J · Juneau, AKBuilt 1968 · S/N 17257453 N46726Taylor David W · Hot Springs, ARBuilt 1968 · S/N 17257455 N46729Thomas Mark R · Clintondale, NYBuilt 1968 · S/N 17257457 N4672FWilmeth Roy · Frankston, TXBuilt 1966 · S/N P206-0272 N4672XAmerican Piston Domestic LLC · Lonsdale, MNBuilt 1966 · S/N 15064722 N46730Zahn Christopher W · Edwardsville, ILBuilt 1968 · S/N 17257458 N46731Laurel Highlands Aeronautical Academy LLC · Latrobe, PABuilt 1968 · S/N 17257459 N46736Krantz Gwendolyn A · Advance, NCBuilt 1968 · S/N 17257460 N46737Berney John E · Morgan Hill, CABuilt 1968 · S/N 17257461 N4673FCody Richard A · Mclean, VABuilt 1966 · S/N P206-0273 N4673XRegistration Pending · Bloomingdale, OHRegistration pendingBuilt 1966 · S/N 15064723 N46742Barlet Richard D · Carthage, MOBuilt 1968 · S/N 17257463 N46743Longino Thomas G · Celeste, TXBuilt 1968 · S/N 17257464 N46744Harrison Airplane LLC · Cynthiana, KYBuilt 1968 · S/N 17257465 N46746Dunlap Gary P · Seattle, WABuilt 1968 · S/N 17257466 N4674XSaunders Christopher · Lehighton, PABuilt 1966 · S/N 15064724 N4675XBlalock Merrel K III · Mayflower, ARS/N 15064725 N4677LJet Airways Express Inc · Aventura, FLBuilt 1966 · S/N 17254672 N4677XBaird Harvey L · Sharon, OKFirst renewal noticeS/N 15064727 N4678FMullett Sean · Cleveland, TNBuilt 1966 · S/N P206-0278 N4679LFitting Solutions Lc · Chester, NJBuilt 1966 · S/N 17254674 N4679XVentura Joel · Andover, MABuilt 1966 · S/N 15064729 N467AT467at LLC · Frankfort, ILBuilt 1968 · S/N 17700879 N4680LWasilowski Steven P · Elgin, ILBuilt 1966 · S/N 17254675 N4681FFisher Adam · Corona, CABuilt 1966 · S/N P206-0281 N4681LOmer Syeda · Gilroy, CAS/N 17254676 N4682LJones Carl R · Little Rock, ARBuilt 1966 · S/N 17254677 N4683LLawson Seth A · Morgantown, WVBuilt 1966 · S/N 17254678 N4684LHowell Tyler L · Romoland, CABuilt 1966 · S/N 17254679 N4685FRulewicz Dennis G · Jackson, MIBuilt 1966 · S/N P206-0285 N4685LEsquilin Steven C · Poway, CABuilt 1966 · S/N 17254680 N4685XFite Robert G · Brookings, SDBuilt 1966 · S/N 15064735 N4687LKful Inc · Fullerton, CABuilt 1966 · S/N 17254682 N4688LFas Aircraft Aerowork Corp · Miami, FLBuilt 1966 · S/N 17254683 N4688XMather Paul L · Saint Elmo, ALBuilt 1966 · S/N 15064738 N4689XGerard Aircraft Inc · Johnson, KSBuilt 1966 · S/N 15064739 N468CCBountiful Flying Club LLC · Salt Lake City, UTS/N 18259357 N4692LBravo Aviation LLC · Rexburg, IDS/N 17254687 N4692XMelvin Jet · Bedford, INS/N 15064742 N4693LEmerald Air LLC · Snohomish, WABuilt 1966 · S/N 17254688 N46940Registration Pending · Como, MSRegistration pendingBuilt 1967 · S/N 17255577 N4694LSky Tours LLC · Port Clinton, OHBuilt 1966 · S/N 17254689

Back to AD 72-03-03 R3