Registered aircraft · 20,687

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N9811VSteffek Mark E · Alturas, CABuilt 1974 · S/N 17264511 N98120Blue River Aviation LLC · Palmer, AKBuilt 1984 · S/N 17276260 N98125Western Reserve Flight Center Inc · Mc Donald, OHBuilt 1984 · S/N 17276261 N9812BPavco Inc · Gig Harbor, WABuilt 1982 · S/N 172RG1046 N9812JMelbourne Flight Training LLC · Melbourne, FLBuilt 1980 · S/N 17273920 N9812TBucks Flight Academy LLC · Cashion, OKS/N 47612 N9813BTsiper Evgueni · Eagan, MNBuilt 1982 · S/N 172RG1047 N9813LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276616 N9813THenley Enterprises Inc · Mangonia Park, FLBuilt 1960 · S/N 47613 N9813VArf Corporation · Brooklyn, NYBuilt 1974 · S/N 17264512 N9814TWickizer Stephen W · Knoxville, TNBuilt 1960 · S/N 47614 N9815GKenmore Air Harbor LLC · Kenmore, WABuilt 1971 · S/N 17259715 N9815LWestosha Flying Club Inc · Kenosha, WIBuilt 1986 · S/N 17276618 N9816GRicker Harry K · Turner, MEBuilt 1971 · S/N 17259716 N9817GLester Matthew J · Gouldsboro, MEBuilt 1971 · S/N 17259717 N98186Loyer Jeffrey W · Olympia, WAS/N 17276265 N98188Usda Forest Service Fepp · Columbia, SCS/N R1720077 N9818GGough Gregory · Emmett, IDBuilt 1971 · S/N 17259718 N981BCSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1998 · S/N 17280464 N981BTPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1998 · S/N 17280430 N981CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280215 N981MARed Rose Flight Tours LLC · Lancaster, PABuilt 1978 · S/N 17271239 N981SFAtp Aircraft 1 LLC · Wilmington, DEBuilt 2013 · S/N 172S11293 N981SPLlp Leasing Group LLC · Lewes, DEBuilt 1999 · S/N 172S8183 N981TWKent Mark · Holden, MABuilt 2002 · S/N 172S9081 N981WUEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280555 N9820TSamson Robert C · Waterford, WIBuilt 1960 · S/N 47620 N98219White Jeffrey M · Carlsbad, CABuilt 1984 · S/N 17276266 N9821GGrubelich Mark C · Edgewood, NMBuilt 1971 · S/N 17259721 N9822VJohnson Mark W · Valrico, FLBuilt 1974 · S/N 17264515 N9823LSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1986 · S/N 17276623 N9824JBarksdale James Alan · Florence, ALBuilt 1980 · S/N 17273925 N9824LSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1986 · S/N 17276624 N9824TNeufeld Dwayne A · Coeur D Alene, IDBuilt 1960 · S/N 47624 N9824VSafety In Motion Flight Center · Puyallup, WABuilt 1974 · S/N 17264516 N98251Wings Over Texas Holdings LLC · Denton, TXBuilt 1984 · S/N 17276269 N9825GKanawha Aviators LLC · Bancroft, WVBuilt 1971 · S/N 17259725 N9825TLong Duane C · Baskin, LABuilt 1960 · S/N 47625 N98264Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276271 N98271Mastin Aviation Inc · Pasadena, MDBuilt 1984 · S/N 17276272 N9827GSpencer Jeffrey · Capistrano Beach, CABuilt 1971 · S/N 17259727 N9828LJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1986 · S/N 17276625 N9828TArts Donald W · Lincoln, CABuilt 1960 · S/N 47628 N9829JInflight Corp · Chaffee, MOBuilt 1980 · S/N 17273928 N9829TGeske Kenneth A · Thief River Falls, MNBuilt 1960 · S/N 47629 N982BTWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280307 N982CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280227 N982SKRowe Andrew L Jr · Hope, MEBuilt 1974 · S/N 17264042 N982SPScott Kenneth C · Erie, COBuilt 1999 · S/N 172S8184 N98306United States Air Force Owner · Usaf Academy, COBuilt 1985 · S/N 17276276

Back to AD 90-06-03 R1