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.

N205RTTriple D Cessna LLC · Greenville, SCBuilt 1962 · S/N 205-0014 N2060QAlvarez Manuel B · Linden, MIBuilt 1973 · S/N 177RG0460 N2063QAv8ors LLC · Port Orange, FLBuilt 1973 · S/N 177RG0463 N2064XCurtin Andrew J · Fernandina Beach, FLBuilt 1965 · S/N 18256164 N2067XPank Thomas E · Walkersville, MDBuilt 1965 · S/N 18256167 N2068RSix Lima Papa LLC · Kalispell, MTS/N 18255268 N2069RLazy T Aviation LLC · Ashland, NES/N 18255269 N2069XFrance Frederick M · Gales Ferry, CTBuilt 1965 · S/N 18256169 N206AYOno Yutaka · Torrance, CABuilt 1967 · S/N U206-0820 N206BSBlue Star Gas Fleet Services Co · Central Point, ORBuilt 1968 · S/N P206-0434 N206CGSmalley Glen E · Kasilof, AKS/N P206-0136 N206DJAlum I Tank Inc · Harvard, ILBuilt 1963 · S/N 206-0055 N206DZEvans David J · Parker, COS/N 206-0185 N206ELAir Tuna LLC · Homestead, FLS/N U20604037 N206EZHottois Scott · Whittemore, MIBuilt 1964 · S/N 2060048 N206GTSmith Allen D · Hurricane, UTBuilt 1967 · S/N P206-0374 N206JJ Bear Tours LLC · Homer, AKBuilt 1967 · S/N U2060965 N206JDZulu Flight LLC · Washougal, WABuilt 1968 · S/N P206-0536 N206JFReichert Kenneth J · Deer River, MNBuilt 1965 · S/N P206-0137 N206JJRuff Stephen D · Sandpoint, IDBuilt 1968 · S/N U206-1012 N206JL3 Tango 3 Flight LLC · Boyceville, WIFirst renewal noticeBuilt 1968 · S/N U2061091 N206JVVercoe Jeffrey · Lincoln, MTBuilt 1968 · S/N P206-0556 N206KAir & Opportunity Aviation LLC · Austin, TXBuilt 1969 · S/N U206-1333 N206KCKaralunas David · Anchorage, AKBuilt 1964 · S/N 205-0536 N206KYWings Of Hope · Chesterfield, MOBuilt 1966 · S/N U206-0676 N206PPElohim Airparts Sales LLC · Naples, FLBuilt 1965 · S/N U2060408 N206RBFoster Steven W · Big Lake, AKBuilt 1968 · S/N U206-1068 N206RHPure Sports Inc · Tavares, FLBuilt 1964 · S/N 206-0215 N206RKAlbrecq Robert W · Gardnerville, NVBuilt 1968 · S/N U206-1205 N206SDCampbell William P · Matador, TXBuilt 1964 · S/N P206-0053 N206SKLatschar Barry D · Oklahoma City, OKBuilt 1964 · S/N 206-0211 N206SPHayden Scott · Anchorage, AKBuilt 1965 · S/N P206-0111 N206SVBremmer Randy R · Whitewater, COBuilt 1967 · S/N P206-0460 N206SXLaughlin Audio Video Electric Inc · Santa Ynez, CABuilt 1966 · S/N P206-0316 N206TDHomestead Helicopters Inc · Missoula, MTBuilt 1964 · S/N 206-0242 N206TXBowler Ryan · Saint George, UTS/N P206-0228 N206VTSend North · Anchorage, AKBuilt 1967 · S/N U206-0993 N206WDCritical 32 Degrees LLC · Milton Freewater, ORBuilt 1984 · S/N U20606832 N206XKennedy Benjamin · Boulder, COBuilt 1968 · S/N P206-0479 N206YARantzair Inc · East Wenatchee, WABuilt 1965 · S/N P2060065 N2070KRudy Schmitt · Brookshire, TXBuilt 1964 · S/N 206-0196 N2070XNrt LLC · Maple Valley, WAS/N 18256170 N2072QMeenk Regna L · Las Vegas, NVS/N 177RG0472 N2073RWindler Steven D · Owasso, OKBuilt 1964 · S/N 18255273 N2074AN2074a Aviation LLC · Sheridan, WYBuilt 1968 · S/N 17257138 N2074QStuzenski Patrick E · Shoreham, NYS/N 177RG0474 N2075QHaugen'S Hangar LLC · Williston, NDS/N 177RG0475 N2076QGreen Jason A · Omaha, NEBuilt 1973 · S/N 177RG0476 N2076XStumm Robert W · Cadott, WIBuilt 1965 · S/N 18256176 N2077QDirks Darrel · Marienthal, KSBuilt 1973 · S/N 177RG0477

Back to AD 72-03-03 R3