Skip to content

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.

N8353BRodriguez Antonio M · Presidio, TXFirst renewal noticeBuilt 1957 · S/N 36153 N8353XAcme Racing LLC · Overland Park, KSBuilt 1961 · S/N 17248853 N8354BTri Flight LLC · Cottonwood, MNBuilt 1957 · S/N 36154 N8354LEast Texas Imperial Petroleum LLC · Flint, TXBuilt 1968 · S/N 17256554 N8354UErvin Jerome · Lometa, TXBuilt 1964 · S/N 17252254 N8354XWillow Equip LLC · Fox River Grove, ILBuilt 1961 · S/N 17248854 N8355BBowen Jeffrey N · Jacksonville, NCBuilt 1957 · S/N 36155 N8356ESky West Aviation Inc Trustee · Albuquerque, NMS/N 17272192 N8356UKolb Austin R · Phoenixville, PABuilt 1964 · S/N 17252256 N8357BHarker James P · Blaine, MNS/N 36157 N8358LOc Flight Lessons LLC · Costa Mesa, CABuilt 1968 · S/N 17256558 N8358UN8358u LLC · Knoxville, IABuilt 1964 · S/N 17252258 N8359LBay Lux Ventures LLC · Tampa, FLS/N 17256559 N8359UMusgrove Stacy J · Cunningham, TXS/N 17252259 N835EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13187 N835FGRidgeline Assers LLC · Wilmington, DEBuilt 2025 · S/N 172S13458 N835KSKansas State University · Salina, KSBuilt 2019 · S/N 172S12305 N8360XJk Sparks Inc · Lutz, FLBuilt 1961 · S/N 17248860 N8361BBrim Robert H · Bellingham, WABuilt 1957 · S/N 36161 N8361LMolid Robert J · Dubuque, IABuilt 1968 · S/N 17256561 N8361UBoss Gary W · Bronston, KYS/N 17252261 N8362BDelp Ryan K · Southbury, CTS/N 36162 N8362UJohnson Scott T · Delta, UTS/N 17252262 N8362XMarlow Haley C · Carrollton, MSS/N 17248862 N8363URagsdale Gregory · Peoria, AZS/N 17252263 N8363XKrause Alex E · Oklahoma City, OKS/N 17248863 N8364BDigiacomo Ernest R · Hampton Bays, NYBuilt 1957 · S/N 36164 N8364UElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1964 · S/N 17252264 N8365BHallada David M · Lakeview, MIBuilt 1957 · S/N 36165 N8365LHarbour Aviation LLC · Weatherford, TXBuilt 1968 · S/N 17256565 N8365UHunt Ellwood M · Texarkana, TXBuilt 1964 · S/N 17252265 N8366LCurwin Randy S · Villa Rica, GABuilt 1968 · S/N 17256566 N8366UHob Aero Inc · Freeland, MIBuilt 1964 · S/N 17252266 N8366XAjm Aviation Ventures LLC · Seal Beach, CABuilt 1961 · S/N 17248866 N8367BPrudek Daniel M · Rathdrum, IDFirst renewal noticeS/N 36167 N8367LRay Allens Electronics Inc · Butler, GABuilt 1968 · S/N 17256567 N8367UTb Maintenance And Cleaning LLC · Deltona, FLBuilt 1964 · S/N 17252267 N8367XLawrence Robert J · West Point, VABuilt 1961 · S/N 17248867 N8368LMeltzair LLC · Fryeburg, MEBuilt 1968 · S/N 17256568 N8368XGay Morgan C · Tunkhannock, PABuilt 1961 · S/N 17248868 N8369BO'Keefe Joseph G · Madera, CABuilt 1957 · S/N 36169 N8369LInternational Air Services Inc Trustee · Carson City, NVBuilt 1968 · S/N 17256569 N8369UCamden Aviation LLC · Lewes, DEBuilt 1964 · S/N 17252269 N836EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13190 N836KSKansas State University · Salina, KSBuilt 2019 · S/N 172S12306 N836SPArmadillo Too LLC · Owensboro, KYBuilt 2001 · S/N 172S8726 N8370BKline Nicholas J · Alliance, OHBuilt 1957 · S/N 36170 N8370USimonsen Joshua A · White Salmon, WABuilt 1964 · S/N 17252270 N8372AHegge Sharon D · Marysville, WABuilt 1962 · S/N 17249480 N8372LRed Sky Aviation LLC · Livermore, CABuilt 1968 · S/N 17256572

Back to AD 90-06-03 R1