Registered aircraft · 20,683

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.

N5284VMaznicki Frank W · Fort Lauderdale, FLBuilt 1980 · S/N 172RG0494 N52858Channel Islands Aviation Inc · Camarillo, CABuilt 2002 · S/N 172S9186 N5285HChild Cris · Mapleton, UTBuilt 1975 · S/N 17265395 N5285KBoland Mark J · Anchorage, AKBuilt 1980 · S/N 17274045 N5285VMiddletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1980 · S/N 172RG0495 N5286CUnited Flying Club Inc · Belmont, CABuilt 2002 · S/N 172S9219 N5286EButler Bill · Juntura, ORBuilt 1978 · S/N 17271815 N5286HNieves Irvyn T · Vega Baja, PRBuilt 1975 · S/N 17265396 N52877Weight Malcom E · Spanish Fork, UTBuilt 1981 · S/N 17274626 N5287ELin LLC · Dunn, NCBuilt 1978 · S/N 17271816 N52889Waters Steven D · Kingwood, TXBuilt 1981 · S/N 17274628 N5288TG & S Air Adventures LLC · Jersey City, NJBuilt 2002 · S/N 172S9222 N52891Registered aircraftBuilt 1981 · S/N 17274629 N5289EFlightco Inc · Swainsboro, GABuilt 1978 · S/N 17271818 N528ERMary Air LLC · White Rock, NMBuilt 2001 · S/N 172S8926 N528NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10825 N528SCMaxxum Financial Group Inc · Destrehan, LABuilt 2002 · S/N 172S9210 N528STStanlake Lowell P · Grand Forks, NDBuilt 1972 · S/N 17260868 N528SVFox Leasing Group LLC · Hollywood, FLBuilt 2004 · S/N 172S9754 N5290ESpacely Space Sprockets LLC · Aurora, ORBuilt 2002 · S/N 172S9226 N5290HLevy James L · Clifton Park, NYBuilt 2002 · S/N 172S9230 N5290VSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11025 N5291ALewis Aeronautical LLC · San Antonio, TXBuilt 2009 · S/N 172S11021 N5291EBreslin Denis M · El Cajon, CABuilt 1978 · S/N 17271820 N5291WMaxxum Financial Group Inc · Destrehan, LABuilt 2002 · S/N 172S9234 N52922Northwest Flyers Inc · Marianna, FLBuilt 1981 · S/N 17274635 N5292DAftcloud Inc · Ontario, CAS/N 17272497 N5292EJam Three LLC · Saint George, UTBuilt 1978 · S/N 17271821 N5292KBates Field Aero Club Inc · Mobile, ALBuilt 1980 · S/N 17274048 N5292REss Adventures LLC · Damascus, ARBuilt 1974 · S/N 17263506 N52939Warwas Steven M · Yorktown, TXBuilt 1981 · S/N 17274641 N5293KBrooks Jimmy · O Fallon, ILS/N 17274049 N5294RRemus Stephen J · Warren, MIBuilt 1974 · S/N 17263508 N5294WSonneborn Arthur Aaron · East Leroy, MIBuilt 2003 · S/N 17281186 N52950Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274642 N52953Pacific Fleet Aviation LLC · Rochester, NYBuilt 1981 · S/N 17274644 N5295ETimbers Flying Club · West Branch, MIFirst renewal noticeBuilt 1978 · S/N 17271824 N5295GJohnston Robert · Hico, TXBuilt 1979 · S/N 17273559 N5296DZack Gary J · Sunderland, VTS/N 172S9239 N5296KTorres Ruben E · Toa Alta, PRBuilt 1980 · S/N 17274050 N5296RB&R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 17263510 N5296ZSouthern Sky LLC · Henderson, NVBuilt 2002 · S/N 172S9241 N5297EAtd Pilot Training LLC · Kansas City, MOBuilt 2002 · S/N 172S9242 N5297GChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9243 N5297RWaltman Jack J · Forbes, NDBuilt 1974 · S/N 17263511 N5298DMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 17272500 N5298JBagamaspad Alan M · Reseda, CABuilt 1980 · S/N 17273758 N5298KNew England Aviation LLC · Plainville, CTBuilt 1980 · S/N 17274051 N5298NJ3m Airops LLC · Daytona Beach, FLBuilt 2002 · S/N 172S9244 N5298RMurray Wanda Joyce Trustee · Proctor, MTS/N 17263512

Back to AD 90-06-03 R1