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.

N62098Delta State University · Cleveland, MSS/N 17275211 N6209EReynolds Richard E · Trumansburg, NYBuilt 1959 · S/N 46309 N620EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13051 N620GWBoyer Skip P · Oak Harbor, WABuilt 1972 · S/N 17260486 N620JASilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2000 · S/N 172S8638 N620SPGulf Coast Aviation LLC · New Orleans, LABuilt 2000 · S/N 172S8610 N62104Condor Aero Club Inc · Zelienople, PAS/N 17275213 N6210EHodges Darin C · West Jefferson, NCBuilt 1958 · S/N 46310 N62112Southern Sky Aviation LLC · Dover, TNS/N 17275214 N6211DMcdonald Air Services LLC · Saint Johns, MIBuilt 1979 · S/N 17272638 N6212FParker Helicopter LLC · Watsonville, CABuilt 1979 · S/N 17273167 N6212GLionheart Aviation Services LLC · Fairfax, VABuilt 1979 · S/N 17273579 N6212RPliego M Guillermo M · Corpus Christi, TXS/N 172RG0117 N6213EBeesley Charles F III · Cole Camp, MOBuilt 1959 · S/N 46313 N62142Xin Han Aviation LLC · Atwater, CABuilt 1981 · S/N 17275218 N62144Intermill Glen M Trustee · Eagle Point, ORBuilt 1981 · S/N 17275219 N6215EReinders Gary J · Orange City, IABuilt 1958 · S/N 46315 N6216EPratt Joseph O · Wasilla, AKBuilt 1958 · S/N 46316 N6216RRegistered aircraftBuilt 1979 · S/N 172RG0119 N6217ESchiffel Peter W · Pequannock, NJBuilt 1958 · S/N 46317 N6217NXing Kong Aviation Service LLC · Atwater, CAS/N 17281544 N6218EZephyrhills Flying Club Inc · Tampa, FLBuilt 1958 · S/N 46318 N6218GGoatley Valerie M · Springfield, KYBuilt 1961 · S/N 17248655 N62195Aire Services LLC · Barrigada, GUS/N 17275226 N62199Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 172S10833 N6219EOaks Randall K · Oxnard, CABuilt 1958 · S/N 46319 N621DCResource Extension LLC · Jupiter, FLBuilt 1980 · S/N 172RG0756 N621PMAtp Aircraft 1 LLC · Wilmington, DEBuilt 2012 · S/N 172S11177 N621TCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2000 · S/N 172S8506 N621WHerzog Daniel L · Clinton, MIS/N 17248576 N62209Christiansen Aviation LLC · Wilmington, DES/N 17275229 N6220EStoudt Kristen D · Derby, KSBuilt 1958 · S/N 46320 N62218Above The Clouds Aviation LLC · Middletown, DEBuilt 1981 · S/N 17275230 N6221EAllgeier David G Jr · Taylorsville, KYBuilt 1958 · S/N 46321 N6222EAlexander Tom · Alamogordo, NMBuilt 1959 · S/N 46322 N6223VAxis Aviation LLC · Bloomingdale, GABuilt 1980 · S/N 172RG0593 N62244Christiansen Aviation LLC · Wilmington, DES/N 17275234 N62245Gabrieles Wings LLC · Oldwick, NJBuilt 2008 · S/N 172S10694 N6225RHartman Michael F · Montclair, CABuilt 1979 · S/N 172RG0122 N62266Skylens LLC · Hammond, LAS/N 17275239 N62281Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275242 N62283Flight School Of Gwinnett Inc · Lawrenceville, GAS/N 17275244 N62287Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17275247 N6228KSunset Leasing Inc · Sarasota, FLBuilt 1980 · S/N 17274175 N6228NGreenwich Venture Partners LLC · Greenwich, CTBuilt 2008 · S/N 172S10695 N62296Sale Reported · Signal Hill, CASale reportedS/N 17275249 N6229QChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10697 N622CMMcgill Charles · Sunriver, ORBuilt 2000 · S/N 172S8467 N622DLColorado Aircraft Corp · Watkins, COBuilt 1975 · S/N 17264853 N622EHaggerty Russell P · Bethpage, NYBuilt 1971 · S/N 17260059

Back to AD 90-06-03 R1