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.

N53223Ancherani Robert M · Scranton, PABuilt 1981 · S/N 17274703 N5322PSky Peak Aviation LLC · Los Angeles, CABuilt 2003 · S/N 172S9312 N5322RFreetown Partners LLC · Newark, DEBuilt 1974 · S/N 17263521 N5322TChase 13 LLC · Wilmington, DES/N 17251222 N53236Principles Of Flight Training LLC · Lees Summit, MOBuilt 1981 · S/N 17274709 N53237Jet Air Inc · Iowa City, IABuilt 2003 · S/N 172S9314 N5323EMaierhoffer Henry F · Sylvania, GAS/N 17271837 N5323HCook James N · Mission Viejo, CABuilt 1975 · S/N 17265403 N5323ROld Grove Aviation LLC · Port Charlotte, FLBuilt 1965 · S/N 17252848 N5323TKnueven Timothy P · Brownsboro, ALS/N 17251223 N5324GFloris Flight Services LLC · Midland, TXBuilt 2003 · S/N 172S9315 N5325NSchindler Lawrence A · Chino Valley, AZBuilt 2003 · S/N 172S9317 N5325RBardo Daniel J · Salem, OHBuilt 1965 · S/N 17252850 N53262Fort Leavenworth Flying Activity · Fort Leavenworth, KSBuilt 1981 · S/N 17274713 N53265Jeppesen Employees Flying Association · Englewood, COBuilt 1981 · S/N 17274714 N5326KCornelius Aviation Inc · Mooresville, NCBuilt 1980 · S/N 17274066 N5327GDirty Side Down Aviation LLC · Georgetown, TXS/N 172S9357 N5327JEdb Air Inc · Wilsonville, ORBuilt 2003 · S/N 172S9356 N5327RMcgrath John J · Littleton, COBuilt 1965 · S/N 17252852 N5327TMurphy Shane T · Bird Creek, AKBuilt 1964 · S/N 17251227 N5327VSouthern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281151 N53289Christiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9331 N5328KAvanna LLC · Shaw Island, WABuilt 1980 · S/N 17274067 N5328TDiem James L · Kiel, WIBuilt 1964 · S/N 17251228 N5328YGa Holdings LLC · Moffett Field, CAS/N 172S9270 N5328ZBartow Municipal Airport Development Authority · Bartow, FLBuilt 2003 · S/N 172S9327 N53293Tito Hector · Fayetteville, GABuilt 1981 · S/N 17274716 N5329RDearborn Flying Club Inc · Grosse Pt Shr, MIBuilt 1965 · S/N 17252855 N5329TShort Kenneth L · Setauket, NYBuilt 1964 · S/N 17251229 N532EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13159 N532HFJet Air Inc · Iowa City, IABuilt 2000 · S/N 17280836 N532NDAia Bravo LLC · Henderson, NVBuilt 2011 · S/N 172S11102 N5330TMilne Sales And Services LLC · Lake Geneva, WIBuilt 1964 · S/N 17251230 N5330UBoard Of Trustees Of Southern Illinois University · Murphysboro, ILFirst renewal noticeBuilt 2003 · S/N 17281152 N5331DPurdue Aviation LLC · West Lafayette, INBuilt 1979 · S/N 17272522 N5331GAero Tech Services Inc · Lititz, PABuilt 2003 · S/N 172S9335 N5331KChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9337 N5331RHastings Peter D · Bar Harbor, MEBuilt 1965 · S/N 17252857 N5331TGilchrist William J · Hodges, SCBuilt 2003 · S/N 172S9338 N53323Chester Charter Inc · Chester, CTBuilt 1981 · S/N 17274720 N5332RJohnson Michael Hans · Tuttle, NDBuilt 1965 · S/N 17252858 N5332VMinuteman Aviation Inc · Missoula, MTBuilt 2003 · S/N 172S9341 N5333TParkison Leland Cameron · Battle Ground, WABuilt 1967 · S/N 17256100 N53340N53340 LLC · Boynton Beach, FLBuilt 2003 · S/N 17281160 N5334DProfessionals Aviation Co Inc · Millersburg, OHBuilt 1979 · S/N 17272523 N5334HThirty-Four Hotel · Houlton, MEBuilt 1975 · S/N 17265405 N5334RDasilva Jonathan L · Madera, CABuilt 1965 · S/N 17252861 N5334TBarker Charles W Jr · Collinsville, OKBuilt 1964 · S/N 17251234 N5334UBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281156 N53350Conner Michael J · Scotts Valley, CABuilt 1965 · S/N 17252862

Back to AD 90-06-03 R1