Skip to content

Registered aircraft · 17,023

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.

N143DBBernard Daniel · GrillyBuilt 1965 · S/N 18256678 N143DKReynolds Terry J · Phoenix, AZS/N 15073020 N143TCHarris William D · Topeka, KSBuilt 1962 · S/N 205-0064 N1440GSierra-Mike LLC · Springdale, ARS/N 15072955 N1440QN1440q LLC · Maybee, MIS/N 15072740 N1441FMartin Michal R · Alva, OKBuilt 1966 · S/N 17254936 N1441QSale Reported · Franklin, INSale reportedBuilt 1971 · S/N 15072741 N1442CMakelbust Michael J · Ames, IABuilt 1977 · S/N 17702728 N1442QDelaware Aviation LLC · Sidney, NYBuilt 1971 · S/N 15072742 N1443FNelson Harold G · Pendleton, ORBuilt 1966 · S/N 17254938 N1444FStrope Byron P · Upland, CABuilt 1966 · S/N 17254939 N1444QPelco Aviation Inc · Hampton Bays, NYBuilt 1971 · S/N 15072744 N14455Pinkerton Matthew L · Milton, FLS/N R-172-0143 N14457Stone Kenneth R · Cedar Springs, MIBuilt 1966 · S/N R172-0120 N1445FMorris Loyd Albert · Alvarado, TXBuilt 1966 · S/N 17254940 N14460Ajkj Aviation LLC · Erie, COS/N R1720121 N1446QBeek Dudley Ernest · Miami, FLS/N 15072746 N14472Hoerler Jonathan · Lincoln, ARBuilt 1963 · S/N 18255194 N1447FCook David F · Carthage, MOBuilt 1966 · S/N 17254942 N1448QWjs Aircraft LLC · New Smyrna Beach, FLBuilt 1971 · S/N 15072748 N1449FJanes Brenda · Shepherdsville, KYBuilt 1966 · S/N 17254944 N1449QAero Maintenance Inc · Vancouver, WABuilt 1971 · S/N 15072749 N144CRFrantz David L · Manchester, TNBuilt 1973 · S/N 15075438 N144PWAerowood Aviation LLC · Monroe, NCBuilt 1965 · S/N 17254019 N1450MCrescent Solutions Group LLC · Camden, DEBuilt 1970 · S/N U20601450 N1451FCloud Busters Inc · Summertown, TNBuilt 1966 · S/N 17254946 N1452FHorizon Aviation LLC · Bristow, OKBuilt 1966 · S/N 17254947 N1454CFreespirit Ventures LLC · Bear, DEBuilt 1977 · S/N 17702731 N1455CCaruso Anthony J · Southampton, NYS/N 17702732 N1455QJackson Scott G · Layton, UTS/N 15072755 N1456FBeames Delbert A · Visalia, CABuilt 1966 · S/N 17254951 N1457FAdvanced Aviation LLC · Pontiac, MIBuilt 1966 · S/N 17254952 N1457MStevenson William E · Sutton, AKBuilt 1970 · S/N U20601457 N1458FMaltby Patrick W · Bath, MIS/N 17254953 N1459FGostecnik Gary · Brookshire, TXBuilt 1966 · S/N 17254954 N1459MK And L Aviation Incorporated · Wilmington, DEBuilt 1969 · S/N U20601459 N145PPainter Bryan J · Renton, WABuilt 1963 · S/N 205-0332 N1460FConrad William A · Freedom, WIBuilt 1966 · S/N 17254955 N1461QMarquez Christopher D · Fleming Island, FLBuilt 1971 · S/N 15072761 N1462FLambdin Charles Randall · Wolf Lake, ILBuilt 1966 · S/N 17254957 N1465MBig Mountain Construction LLC · La Grande, ORBuilt 1969 · S/N U20601465 N1466MTabor Shayne · Renville, MNBuilt 1970 · S/N U20601466 N1468MArctic Barnabas Ministries · Kenai, AKBuilt 1970 · S/N U20601468 N146ACUnited States Air Force Owner · Usaf Academy, COBuilt 1967 · S/N R1720147 N146FCUsda Forest Service Fepp · Malvern, ARBuilt 1966 · S/N P206-0247 N146JHGodinez Mauricio U · San Diego, CAS/N 15066426 N1471QRader Gregory · Baldwin City, KSBuilt 1971 · S/N 15072771 N1476QHarley Dennis E Sr · Cole Camp, MOBuilt 1971 · S/N 15072776 N1477FMavity Reagan Chase · Clayton, GABuilt 1966 · S/N 17254972 N1478FElliott Gabrial Adam · Hollywood, ALBuilt 1966 · S/N 17254973

Back to AD 72-03-03 R3