Registered aircraft · 108,433

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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  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:2007-04-19-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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.

N206ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496036 N206AYOno Yutaka · Torrance, CABuilt 1967 · S/N U206-0820 N206BABoeing Company · Mesaon, AZBuilt 1973 · S/N U20602034 N206BCSkelton Thomas N · Madison, MSBuilt 1999 · S/N 20608025 N206BKGo Best Inc · Richmond Hill, GABuilt 2014 · S/N TH-2413 N206BLWright Kim B · Anchorage, AKBuilt 1979 · S/N U20605491 N206BRWest Matthew Shawn · Island, KYBuilt 1981 · S/N U20606350 N206BSBlue Star Gas Fleet Services Co · Central Point, ORBuilt 1968 · S/N P206-0434 N206CBLewis Jeffrey R · Parker, COBuilt 1974 · S/N 28-7425230 N206CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 20608227 N206CTDe Creeft Joseph M · Homer, AKBuilt 1981 · S/N U206-06090 N206CWAgri Med LLC · Belgrade, MTBuilt 1978 · S/N CE-836 N206DP W Feenstra Construction Inc · Queen Creek, AZBuilt 1978 · S/N U20604415 N206DCAri Air LLC · Anchorage, AKBuilt 1976 · S/N U20603198 N206DJAlum I Tank Inc · Harvard, ILBuilt 1963 · S/N 206-0055 N206DMBushwood Air LLC · Coeur D Alene, IDBuilt 1976 · S/N U20603512 N206DZEvans David J · Parker, COS/N 206-0185 N206EJSzymanski Collin Andrew Sr · Anchorage, AKBuilt 1974 · S/N U20602507 N206EKKoch & Koch Inc · Grass Valley, CABuilt 1981 · S/N U20606291 N206EZHottois Scott · Whittemore, MIBuilt 1964 · S/N 2060048 N206FMoreau Aviation LLC · Wasilla, AKBuilt 1975 · S/N U20603015 N206FLRegistered aircraftBuilt 1978 · S/N U20604627 N206FMParrott David C · Harrison, MES/N U20606253 N206FNFlying Neutrons LLC · Lebanon, OHBuilt 1999 · S/N 20608026 N206GSmith Air LLC · Cascade, IDBuilt 1979 · S/N U20605268 N206GAPrijatel Thomas J · Cordova, AKBuilt 1979 · S/N U20605288 N206GCCook Tyler · Seldovia, AKBuilt 2002 · S/N 20608001 N206GKJls Alaska LLC · Palmer, AKBuilt 1981 · S/N U20606100 N206GMDestination Alaska Air Service LLC · Homer, AKS/N U20606837 N206GPAdaptive Aero Inc · Wilmington, DEBuilt 1978 · S/N CE-754 N206GRCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601753 N206GTSmith Allen D · Hurricane, UTBuilt 1967 · S/N P206-0374 N206GVSawtooth Flying Service · Mccall, IDBuilt 1978 · S/N U20604833 N206HCHough Linwood L · Penn Yan, NYBuilt 1978 · S/N U20604356 N206HHSawtooth Flying Service Inc · Mccall, IDBuilt 1980 · S/N U20605675 N206HTPepke Mark E · Memphis, TNS/N 401 N206JJ Bear Tours LLC · Homer, AKBuilt 1967 · S/N U2060965 N206JAFabick John D · Saint Louis, MOBuilt 1999 · S/N 20608014 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 N206JMSouthside Truck And Trailers Inc · San Antonio, TXBuilt 1973 · S/N U20602195 N206JVVercoe Jeffrey · Lincoln, MTBuilt 1968 · S/N P206-0556 N206JWMarley William Jay Jr · Homer, AKBuilt 1981 · S/N U20606283 N206KAir & Opportunity Aviation LLC · Austin, TXBuilt 1969 · S/N U206-1333 N206KCKaralunas David · Anchorage, AKBuilt 1964 · S/N 205-0536 N206KDStubblefield Fancho F Jr Trustee · Amity, ORBuilt 1979 · S/N U20604981 N206KMHoskins Marc R · Kennett, MOBuilt 2001 · S/N 20608153 N206KTStephens Dennis II · Lake Jackson, TXBuilt 2003 · S/N 00127

Back to AD 2007-04-19 R1