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.

N17TCKenyon Walter C · Eureka Springs, ARBuilt 1964 · S/N 21058499 N18004Hause James H · Negley, OHBuilt 1972 · S/N 15073722 N18006Lockhart Curtis M · Bay Village, OHBuilt 1972 · S/N 15073724 N1800FReid Brian M · Boise, IDBuilt 1965 · S/N 21058700 N1800XValentine Edward Lawson · Dallas, TXFirst renewal noticeBuilt 1964 · S/N 18255900 N18015Little Bird 150 LLC · Lake Tapps, WABuilt 1972 · S/N 15073732 N1801XClark Curtis S · New Carlisle, OHBuilt 1965 · S/N 18255901 N1801ZGould Robert R Jr · Sterling, VABuilt 1962 · S/N 205-0001 N18020N18020 LLC · Chandler, AZBuilt 1972 · S/N 15073736 N18021Tilden Jeffrey D · Columbus, INS/N 15073737 N18023Remain In The Pattern LLC · Meridian, IDBuilt 1972 · S/N 15073739 N18025Evans II Rodney D · Saint Albans, WVBuilt 1972 · S/N 15073741 N18026Registered aircraftBuilt 1976 · S/N 17702525 N1802FSantiago Ferdinand · Calhoun, GABuilt 1965 · S/N 21058702 N1802ZSparks Timothy J · Jackson, MIBuilt 1962 · S/N 205-0002 N18032Old School Aircraft LLC · Jackson, TNBuilt 1972 · S/N 15073747 N18033Barkley John · Austin, TXBuilt 1972 · S/N 15073748 N18038Overton Asset Group LLC · St Marys, IABuilt 1976 · S/N 17702526 N18042Carey Daniel F · Rockville Centre, NYS/N 15073754 N18046Beavers David A · Strasburg, COS/N 15073757 N1804FWaage Todd · Greenbush, MNBuilt 1965 · S/N 21058704 N18050Jarrell Loyd F · Whitesburg, TNBuilt 1972 · S/N 15073759 N18052Sky Views LLC · Mount Crawford, VABuilt 1972 · S/N 15073760 N18057Palmer Jedidiah J · Lewiston, IDS/N 15073763 N18061Foster Rodney D · Quanah, TXBuilt 1972 · S/N 15073765 N18067Get Out Aviation LLC · Palmer, AKS/N 15073769 N18069Olandese Donald J · Newalla, OKBuilt 1972 · S/N 15073771 N1806XBrowning Lonnie O IV · Allendale, SCS/N 18255906 N18071Rock River Aviation · Watertown, WIBuilt 1972 · S/N 15073773 N18076Angelos Mark A · Concord, CAS/N 15073776 N18081Eyes Above LLC · Hampton Falls, NHBuilt 1972 · S/N 15073780 N18088Durin Steven C · Steward, ILS/N 15073784 N1808XM&M Land Company LLC · Marietta, OHBuilt 1964 · S/N 18255908 N1808ZFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVNon-citizen corporation, flight hours not reportedBuilt 1962 · S/N 205-0008 N1809XMilburn Thomas D Trustee · Lompoc, CABuilt 1964 · S/N 18255909 N1809ZCleared For Departure LLC · Kennewick, WABuilt 1962 · S/N 205-0009 N18100Liberty University School Of Aeronautics · Lynchburg, VABuilt 1972 · S/N 15073785 N18104Toth Stephen K · Northampton, PABuilt 1972 · S/N 15073788 N18109Szoke Elliott · Mukilteo, WAS/N 15073792 N1810ZRanzway Corp · Seattle, WABuilt 1962 · S/N 2050010 N18110Radke Steven H · Hastings, MNBuilt 1972 · S/N 15073793 N18115Hinds Community College · Raymond, MSBuilt 1972 · S/N 15073796 N1811XAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1964 · S/N 18255911 N18126Harroun Charles G · Maryville, MOBuilt 1972 · S/N 15073804 N18129Loftics LLC · Kennewick, WABuilt 1976 · S/N 17702530 N1812XDavid Glen E · Ash Fork, AZS/N 18255912 N18140Johnroe Ryan M · Mount Pleasant, MIBuilt 1972 · S/N 15073815 N18144Kachemak Bay Flying Service · Temple, TXBuilt 1972 · S/N 15073817 N18145Stlouis Aviation LLC · Miramar, FLBuilt 1972 · S/N 15073818 N1814FAlpine Cable And Construction Inc · Grand Junction, COBuilt 1965 · S/N 21058714

Back to AD 72-03-03 R3