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.

N317KAWycka Michelle Sarah · Stayton, ORS/N 18254317 N318Liberty University School Of Aeronautics · Lynchburg, VAFirst renewal noticeBuilt 1966 · S/N R172-0006 N3180QA & L Aircraft Holding LLC · Miami Springs, FLBuilt 1967 · S/N 18258180 N3180RThomas Lance E Trustee · Mesa, AZBuilt 1967 · S/N 18258580 N3180UBasan Oasis LLC · Santa Teresa, NMBuilt 1963 · S/N 18254580 N3180YWalker Jim · Lovell, WYBuilt 1962 · S/N 18254180 N3181SWood David M · Purcellville, VABuilt 1964 · S/N 18255681 N3181TDuck Donald S · Edwardsburg, MIBuilt 1967 · S/N 17700481 N3181XHart George · Roseville, CABuilt 1966 · S/N 15064581 N3182QMagnusson Ralph L · Wyoming, MNBuilt 1967 · S/N 18258182 N3182RSeven Hills Sky Divers Inc · Madison, WIBuilt 1967 · S/N 18258582 N3182SRyan Aviation Management LLC · Palm Coast, FLBuilt 1964 · S/N 18255646 N3182UGarcia-Martinez Jose Victor · Birmingham, ALBuilt 1963 · S/N 18254582 N3182XHerrera Lizann · Sumner, WABuilt 1966 · S/N 15064582 N3182YHeckethorn Philipp · Baker, NVBuilt 1962 · S/N 18254182 N3183JRank Brian Andrew · Oxford, MIBuilt 1966 · S/N 15065883 N3183QMj Syndicate LLC · Vancouver, WAS/N 18258183 N3183RRusso Anthony G · Melbourne Beach, FLS/N 18258583 N3183SJohnson Richard · Winnebago, MNBuilt 1964 · S/N 18255683 N3183XTrimble John Sr · Stone Mountain, GABuilt 1966 · S/N 15064583 N3183YAlc Aviation LLC · Milwaukee, WIBuilt 1962 · S/N 18254183 N3184QBeaugh Anthony H · Platteville, COBuilt 1967 · S/N 18258184 N3184RGardner Daniel J · Alvord, TXBuilt 1967 · S/N 18258584 N3184SThrash Farms Inc · Pelahatchie, MSBuilt 1964 · S/N 18255684 N3184XSandlapper Aviation Of De · Bennington, VTBuilt 1966 · S/N 15064584 N3184YFunkhouser David E · Weatherford, OKBuilt 1962 · S/N 18254184 N3185F85 Foxtrot LLC · Redmond, ORS/N 18257285 N3185QPara Tactics LLC · Shelton, WABuilt 1967 · S/N 18258185 N3185XSanders John L · Sikeston, MOS/N 15064585 N3185YGochenour Air Inc · Fort Wayne, INBuilt 1962 · S/N 18254185 N3186JHowenstein John G · Roseville, CABuilt 1966 · S/N 15065886 N3186QKimbril Steve · Hartselle, ALBuilt 1967 · S/N 18258186 N3186RHuey Gale R · Celeste, TXBuilt 1967 · S/N 18258586 N3186XPanus Mark V · Hinsdale, NYBuilt 1966 · S/N 15064586 N3186YJram Air Parts LLC · Henderson, NVBuilt 1962 · S/N 18254186 N3187FVolatile Aero Ventures LLC · Boulder City, NVBuilt 1966 · S/N 18257287 N3187JBrar Amuldeep S · Austin, TXBuilt 1966 · S/N 15065887 N3187UMillikan Kimball S · Honolulu, HIBuilt 1963 · S/N 18254587 N3187YMiller Richard G · Anson, TXS/N 18254187 N3188JFlight Time Builders Inc · Memphis, TNBuilt 1966 · S/N 15065888 N3188QLutz Paul A Trustee · Seville, OHBuilt 1967 · S/N 18258188 N3188SCrossman Charles · Rusk, TXBuilt 1964 · S/N 18255688 N3188TRucinski Edward A · Climax, NCS/N 17700488 N3188UAsb Avionics LLC · Mojave, CABuilt 1963 · S/N 18254588 N3188YIngram Patrick Joseph · Pinedale, WYS/N 18254188 N3189SMarvin Franz Interests Inc · Victoria, TXS/N 18255689 N3189ULaney Donald R · Inkster, MIS/N 18254589 N318CCVan Schoonhoven Nicholas R · Kent, WABuilt 1966 · S/N 18257289 N318VFShramek Troy A · Bossier City, LABuilt 1973 · S/N 17702008 N3190FTimbol Julius J · Fair Oaks, CABuilt 1966 · S/N 18257290

Back to AD 72-03-03 R3