Skip to content

Registered aircraft · 17,028

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.

N8134FHammond Steven R · Trenton, MOBuilt 1966 · S/N 15064234 N8134UColey Lee · Fayetteville, GABuilt 1964 · S/N 17252034 N8135SMcjunkin John Michael · Portland, ORRegistration revokedBuilt 1965 · S/N 15061735 N8136FRawson Aviation LLC · Ardmore, OKBuilt 1966 · S/N 15064236 N8136SPockrus Pat B · Mineral Wells, TXS/N 15061736 N8136UMoors Thomas G · Wentzville, MOBuilt 1964 · S/N 17252036 N8137GTwo Ten K LLC · Upper Sandusky, OHBuilt 1971 · S/N 21059437 N8137ZSullivan Harry Stuard Trustee · Banning, CABuilt 1962 · S/N 205-0137 N813HYOcala Aviation Services Inc · Ocala, FLBuilt 1964 · S/N 17252033 N813JWComanche Air Inc · Tacoma, WAFirst renewal noticeBuilt 1972 · S/N 177RG0294 N8140UAnderson Milton M · Twin Bridges, MTS/N 17252040 N8141SRegistration Pending · La Porte, TXRegistration pendingBuilt 1965 · S/N 15061741 N81424Wbair LLC · Wills Point, TXS/N 17256218 N8142SRebich Jason F · Overton, NVBuilt 1965 · S/N 15061742 N8142UMartin Ralph Edward · Jonesboro, ARBuilt 1964 · S/N 17252042 N8142ZHayes Allen D · La Grange, KYBuilt 1962 · S/N 2050142 N8143GRegistration Pending · Sparks, NVRegistration pendingBuilt 1971 · S/N 21059443 N8143SElite Aeronautics LLC · Carolina, PRBuilt 1965 · S/N 15061743 N8143UJon Boyd Beard · Houston, TXBuilt 1964 · S/N 17252043 N8143ZMoojens LLC · San Carlos, CABuilt 1962 · S/N 205-0143 N8144SRegistered aircraftBuilt 1965 · S/N 15061744 N8145SBissat Rishid H · Visalia, CABuilt 1965 · S/N 15061745 N8146UBearce Todd A · Phoenix, AZS/N 17252046 N8147SHoehn Ronald T · Perryville, MOS/N 15061747 N814BMMcdaniel Robert L · Columbia, ILBuilt 1966 · S/N 17255216 N814DEDickinson Dennis D · St Pete Beach, FLBuilt 1966 · S/N 17254192 N814RReed Mackenzie · Princeton, TXS/N 17260405 N8150LKal Aero Flight Instruction LLC · Mattawan, MIBuilt 1967 · S/N 17256350 N8151FMitchell John F · Shannon, ILBuilt 1966 · S/N 15064251 N8151LBrown Gary D · Rainbow City, ALBuilt 1967 · S/N 17256351 N8151UYork George T · Harvard, ILBuilt 1964 · S/N 17252051 N8152LBowman Douglas M · Elyria, OHBuilt 1967 · S/N 17256352 N8152UGentry James L · Englewood, TNBuilt 1964 · S/N 17252052 N8153LTr Air LLC · Kenton, OHBuilt 1967 · S/N 17256353 N8153SBelli Tony G · Huron, OHBuilt 1965 · S/N 15061753 N8153UGorman Shawn Michael · Van Wert, OHBuilt 1964 · S/N 17252053 N8154FWilson Gary L · Levant, MES/N 15064254 N8154UPodgorski James E · Walworth, WIBuilt 1964 · S/N 17252054 N8154ZTurner Company LLC · Hearne, TXBuilt 1962 · S/N 205-0154 N8155FJapundza Bob · Kokomo, INBuilt 1966 · S/N 15064255 N8155SSale Reported · Cherry Valley, CASale reportedS/N 15061755 N8155UShearer Ronald L · Quincy, INBuilt 1964 · S/N 17252055 N8156FKindlon Aviation Inc · Glenmont, NYBuilt 1966 · S/N 15064256 N8156SPyanov Mark · Clinton, MSS/N 15061756 N8157LWinfrey Walter A Trustee · Auburn, CAS/N 17256357 N8157SAntal Frank Jr · Delta, COBuilt 1965 · S/N 15061757 N8157UQuarter To Two Flying Club Inc · Williamsport, PABuilt 1964 · S/N 17252057 N8158LBockman Peter Jr · Anchorage, AKS/N 17256358 N8160FRydell Leonard A · Newberg, ORBuilt 1966 · S/N 15064260 N8160LGarcia Geoff M · Tecumseh, OKBuilt 1967 · S/N 17256360

Back to AD 72-03-03 R3