Registered aircraft · 68,375

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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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.

N36JPPasseno Jeff P · Palatka, FLBuilt 1990 · S/N 994 N36JWBarr Air Patrol LLC · Mesquite, TXBuilt 1975 · S/N 17265589 N36KGBarry Robin · Lake Charles, LABuilt 1955 · S/N 18-4586 N36KLZoellner Jackson T · Sioux Falls, SDBuilt 2002 · S/N 555 N36MDWoods Aviation LLC · Elnora, INBuilt 1978 · S/N 117HP N36MXDevlin William Lee · Greeley, COBuilt 1982 · S/N 280 N36PATrevathan Max Tyler · Dyersburg, TNBuilt 2001 · S/N 3826 N36PFFoley Philip · Rathdrum, IDBuilt 2020 · S/N 90327 N36PMPurvinas Martin H · Colton, ORBuilt 2007 · S/N 93-0608 N36QSchindler Donald G · Springfield, ORBuilt 1977 · S/N 909 N36RBEngelmann Randal · West Palm Beach, FLBuilt 1966 · S/N 28-22384 N36SCEdwards Thomas E · Brighton, COS/N 001 N36SVAviat Aircraft Inc · Afton, WYBuilt 2025 · S/N 3460 N36WALandreth Kevin R · Ponca City, OKBuilt 1964 · S/N 30-581 N36WCBanos Joseph A · Saint George, UTBuilt 1996 · S/N 23174 N36ZQNorthern Flights LLC · Calumet, MIBuilt 1975 · S/N 17265019 N3700ACall One Inc · Clarinda, IABuilt 1953 · S/N 22-1942 N3700KMathews Nancy M · Englewood, TNBuilt 1967 · S/N 28-23694 N3700TBrickner Gary K · North Highlands, CAS/N 28R-30004 N3701KCdm Atlanta Inc · Tyrone, GABuilt 1967 · S/N 28-23696 N3701PDibbell David L · South New Berlin, NYBuilt 1958 · S/N 22-6184 N3701RScarpelli Jim · Wichita, KSBuilt 1970 · S/N 28-5393 N3701TStewarts Aircraft Service Inc · Waynesville, OHBuilt 1967 · S/N 28R-30005 N3702FBuzjob Aviation LLC · Los Angeles, CABuilt 1976 · S/N 0739 N3702POlson Ezra Ross · Kingman, KSFirst renewal noticeBuilt 1955 · S/N 22-3418 N3702TDelp Thomas W · Rensselaerville, NYFirst renewal noticeBuilt 1967 · S/N 28R-30006 N3703FPresby Aire LLC · Berlin, NHBuilt 1976 · S/N 0738 N3703PEvans Christopher W · Demotte, INBuilt 1955 · S/N 22-3419 N3703RAlexandria Flying Club Inc · Alexandria, MNBuilt 1970 · S/N 28-5769 N3703XFortney Robert F · West Hollywood, CABuilt 1968 · S/N 5004 N3704MLacroix Robert Emile Jr · Orlando, FLS/N 28R-7837130 N3704PAlderman Mark C · Wasilla, AKBuilt 1955 · S/N 22-3420 N3704TStevens Michael J · Punta Gorda, FLBuilt 1967 · S/N 28R-30008 N3704ZGray Melinda G · Milan, ILBuilt 1960 · S/N 22-7573 N3705FMonteith Andrew W · Lebanon, PABuilt 1977 · S/N 0750 N3705TN3705t LLC · Dallas, TXBuilt 1967 · S/N 28R-30009 N37068Lutz Terry L · Williamston, MIBuilt 1941 · S/N 1729 N3706CGustafson Gail M · White Hall, MDS/N 3861 N3706KRegistration Pending · Cedar City, UTRegistration pendingBuilt 1967 · S/N 28-23699 N3706NJsn Aviation LLC · Huntersville, NCBuilt 1967 · S/N 680044 N3706TFinished Work Aviation LLC · Redding, CABuilt 1967 · S/N 28R-30010 N3706WAshby Sharon · Flora, INBuilt 1980 · S/N WA-178 N3706ZHall John L · Port Angeles, WABuilt 1960 · S/N 22-7575 N3707AMorris Charles W · Wasilla, AKFirst renewal noticeBuilt 1958 · S/N 18-3388 N3707BSampson Gary W · Cedar Rapids, IABuilt 1980 · S/N WA-177 N3707GHooker Kenneth R · Sheridan, ARBuilt 1980 · S/N WA-184 N3707PHamm Russell K · Owasso, OKBuilt 1955 · S/N 22-3423 N3708AFreyburger Paul W · Java Village, NYBuilt 1956 · S/N 18-3389 N3708PAeromarine Consulting Inc · Brandon, FLBuilt 1955 · S/N 22-3424 N3708XHammon Justin M · Colorado City, AZBuilt 1968 · S/N 5009

Back to AD 90-04-06 R1