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.

N9583BBurke Larry Ryan · Pembroke, GABuilt 1981 · S/N 172RG0898 N9584B360 Marine · Bristol, RIBuilt 1981 · S/N 172RG0899 N9584VStick & Rudder Club Inc · Waukegan, ILBuilt 1974 · S/N 17264386 N9585VHarrington Aviation LLC · Scarborough, MEBuilt 1974 · S/N 17264387 N9587VPinnick Brent E · West Baden Springs, INBuilt 1974 · S/N 17264389 N9588VKachemak Bay Flying Service Inc · Temple, TXBuilt 1975 · S/N 17264390 N9589HFryar Scott D · Starke, FLBuilt 1975 · S/N 17266248 N958EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S13004 N9591BSmith Justin T · Marshfield, WIBuilt 1981 · S/N 172RG0904 N9593BBehnke Christopher H · SiegburgBuilt 1981 · S/N 172RG0906 N9593HSaliba Bahig Nadim · Scottsdale, AZBuilt 1975 · S/N 17266252 N9593VWeaver Robert D · Petersburg, WVBuilt 1974 · S/N 17264395 N9594HEagle Sky Patrol Inc · Deadwood, SDS/N 17266253 N9596HCorby Brenda K · Oak View, CABuilt 1976 · S/N 17266255 N9597VSkelton Jeffrey · Sioux Falls, SDBuilt 1974 · S/N 17264399 N9598BIpsen Michael · Kenosha, WIBuilt 1981 · S/N 172RG0909 N9598HImsar LLC · Springville, UTBuilt 1975 · S/N 17266256 N959HCNorthwest Wings LLC · Hillsboro, ORBuilt 1973 · S/N 17262361 N959JATriple Eagle Aviation LLC · Cambridge, VTBuilt 2007 · S/N 172S10510 N959RMLargent Richard B · Southport, NCBuilt 1970 · S/N 17259113 N959UAUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2007 · S/N 172S10526 N959YBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12959 N95BPPeraton Services LLC · Bozeman, MTBuilt 2012 · S/N 172S11108 N95CPGates Thomas S · Moyock, NCBuilt 1976 · S/N 17265896 N95GCGrant James T · Huntsville, ALBuilt 1960 · S/N 47386 N95JALane Christopher C · Dallas, TXBuilt 1979 · S/N 172RG0015 N9601QSteel Aviation Inc · Walnut Cove, NCBuilt 1975 · S/N 17265686 N9602BLaguna Verde Leasing Inc · Wilmington, DES/N 172RG0912 N9603QConnecticut Flyers Inc · Madison, CTBuilt 1975 · S/N 17265688 N9605QBragan Ryan J · Dunedin, FLBuilt 1975 · S/N 17265690 N9607HTwin Oaks Airpark Inc · Hillsboro, ORFirst renewal noticeBuilt 1975 · S/N 17266260 N9608HCag Aircraft Holdings LLC · Crystal River, FLBuilt 1975 · S/N 17266261 N9608QLahmers Melvin E · Newcomerstown, OHBuilt 1976 · S/N 17265693 N9609QWestrup Gregory W · Greensburg, INBuilt 1975 · S/N 17265694 N960AUAuburn University · Auburn, ALBuilt 2017 · S/N 172S12098 N960FSSouthern Aero LLC · Homestead, FLBuilt 1974 · S/N 17263386 N960MSMt San Antonio Community College District · Walnut, CABuilt 2001 · S/N 172S8859 N960TAInnoutaero LLC · Stockton, CAS/N 172S8960 N96100Trajectory Aviation LLC · Hollywood, FLBuilt 1983 · S/N 17276020 N96105Demon Air LLC · Palm City, FLS/N 17276023 N9610QUS Aviation Group LLC · Denton, TXBuilt 1976 · S/N 17265695 N9612HRegistration Pending · Ocean Isle Beach, NCRegistration pendingBuilt 1975 · S/N 17266263 N9613HFiedler Mark · Wichita, KSBuilt 1975 · S/N 17266264 N9614HC&H Elite Air LLC · Johnstown, COBuilt 1975 · S/N 17266265 N9614QConrad Terry E · Lancaster, OHBuilt 1975 · S/N 17265699 N9616LMid Island Air Service Inc · Ronkonkoma, NYBuilt 1986 · S/N 17276590 N9616QClearview Flying Club Inc · Westminster, MDBuilt 1975 · S/N 17265701 N9617HShinn Lake D · Stevensville, MTBuilt 1976 · S/N 17266267 N9617QKagin Corp · Wilmington, DEBuilt 1975 · S/N 17265702 N96180Jb Aviation · Bolingbrook, ILBuilt 1983 · S/N 17276034

Back to AD 90-06-03 R1