Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N206EJSzymanski Collin Andrew Sr · Anchorage, AKBuilt 1974 · S/N U20602507 N206EKKoch & Koch Inc · Grass Valley, CABuilt 1981 · S/N U20606291 N206ELAir Tuna LLC · Homestead, FLS/N U20604037 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 N206GSmith Air LLC · Cascade, IDBuilt 1979 · S/N U20605268 N206GAPrijatel Thomas J · Cordova, AKBuilt 1979 · S/N U20605288 N206GBBoyd Michael A · Leoma, TNS/N U206-05738 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 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 N206KWCoyote Air LLC · Fairbanks, AKBuilt 1977 · S/N U20603762 N206KYWings Of Hope · Chesterfield, MOBuilt 1966 · S/N U206-0676 N206LFBoruch Joseph · Old Lyme, CTBuilt 1980 · S/N U20605436 N206LMQualitair LLC · MichelstadtBuilt 1977 · S/N U20603759 N206MCPittock Troy · Fort Worth, TXBuilt 1973 · S/N 17261461 N206MGIndependence Aviation Inc · La Porte City, IAS/N U20603910 N206MLFiedler Jean M · Sauk Centre, MNBuilt 1979 · S/N U20605253 N206MMHoistad Rick A · Forman, NDBuilt 1976 · S/N U20603318 N206MVBrownlie Michael V · Chandler, AZS/N U20606539 N206NMoose Venutres LLC · Palo Alto, CABuilt 1977 · S/N U20603912 N206NMSug-Air LLC · Lubbock, TXS/N U20603132 N206PBHolland John R · Jacksonville, FLBuilt 1977 · S/N U20603781 N206PDRockwell Collins Inc · Cedar Rapids, IABuilt 1977 · S/N 676 N206PKCardinal Aviation LLC · Gaines, MIBuilt 1978 · S/N U20604341 N206PPElohim Airparts Sales LLC · Naples, FLBuilt 1965 · S/N U2060408 N206PTSamaritan Aviation Inc · Mesa, AZBuilt 1980 · S/N U20605815 N206PYGreen Todd · Anchorage, AKBuilt 1975 · S/N U20602795 N206QVan Valin Scott E DBA · Craig, AKBuilt 1976 · S/N U20603259 N206RBFoster Steven W · Big Lake, AKBuilt 1968 · S/N U206-1068 N206RCPaloma Aviation LLC · Fruitland, IDBuilt 1974 · S/N U20602431

Back to AD 98-21-21 R1