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.

N84599Nichols Investment And Rental LLC · Ogden, UTBuilt 1969 · S/N 17258543 N8459LBelcher Otha A · Centreville, ALBuilt 1968 · S/N 17256659 N8459ULucci Giacinto A · Nashville, MIS/N 17252359 N845EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13511 N845KSKansas State Univeristy · Salina, KSBuilt 2022 · S/N 172S12835 N845ZDornoch Services LLC · Dover, DEBuilt 2001 · S/N 172S8822 N84604Sky Aviation Corp · Staten Island, NYBuilt 1969 · S/N 17258546 N8461LScott Gerald D · Fieldon, ILBuilt 1968 · S/N 17256661 N84628Flying W Enterprises LLC · Shelton, WABuilt 1969 · S/N 17258552 N8462XSmith Richard J · Jackson Springs, NCBuilt 1961 · S/N 17248962 N84633Eckhardt Bridget A · Chugiak, AKBuilt 1969 · S/N 17258554 N84634Johnson Marty C · De Berry, TXBuilt 1969 · S/N 17258555 N8463LColon Wilfredo Beneto · Lake Dallas, TXBuilt 1968 · S/N 17256663 N8463UDixon Steven M · Waynesboro, GABuilt 1964 · S/N 17252363 N84642Elder Russell W · Kirbyville, TXBuilt 1969 · S/N 17258558 N84644Dixon Paul C · Gilbert, AZBuilt 1969 · S/N 17258559 N84647Falcons Aloft LLC · Friday Harbor, WABuilt 1969 · S/N 17258560 N8464UOrmat Glenn · Wakarusa, INS/N 17252364 N8464XBistline Leland K · Fredonia, AZBuilt 1961 · S/N 17248964 N84656Mitchell Larry Trustee · Kingsland, ARBuilt 1969 · S/N 17258564 N84657Myler Mitchell · Bluffdale, UTBuilt 1969 · S/N 17258565 N84659Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1969 · S/N 17258566 N8465XMaynard Craig A · Dedham, MEBuilt 1961 · S/N 17248965 N84662Caverns Consulting LLC · Purcellville, VABuilt 1969 · S/N 17258569 N8466EGoldstein Allan · Elk Grove Village, ILBuilt 1979 · S/N 17272207 N8466LWild Blue Yonder LLC · Lewes, DES/N 17256666 N8466XEagle East Aviation Inc · North Andover, MAS/N 17248966 N84678Elizabethtown Flying Service Inc · Elizabethtown, KYBuilt 1969 · S/N 17258573 N8467USkyhawk Aviators LLC · Clayton, WAS/N 17252367 N84686Registered aircraftBuilt 1969 · S/N 17258577 N84688Quad Cities Aero LLC · Bettendorf, IABuilt 1969 · S/N 17258578 N8468LMidstate Aviation 1 LLC · Owosso, MIBuilt 1968 · S/N 17256668 N8468UWarne Cory S · Granbury, TXBuilt 1964 · S/N 17252368 N84695Pike Mark D · Victorville, CABuilt 1969 · S/N 17258581 N8469LZitko Philip R · Shelby, OHBuilt 1968 · S/N 17256669 N8469UTaylor Aviation Inc · Fort Benton, MTBuilt 1964 · S/N 17252369 N8469XEagan Timothy H · Casa Grande, AZBuilt 1961 · S/N 17248969 N846CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12630 N846DLRodgers William B · Dearing, GABuilt 1969 · S/N 17257927 N846EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12798 N846KSKansas State University · Salina, KSBuilt 2022 · S/N 172S12836 N846SPSky Cag LLC · Hermosa Beach, CABuilt 2001 · S/N 172S8755 N8470UEagle Sky Patrol · Deadwood, SDBuilt 1964 · S/N 17252370 N84717Worldwide Warbirds Inc · Heber City, UTBuilt 1969 · S/N 17258589 N84721Tail Aero Corp · Wilmington, DES/N 17258591 N8473EBeck Roger M Trustee · Goode, VABuilt 1979 · S/N 17272208 N8473UGerding Timothy A · Philomath, ORBuilt 1964 · S/N 17252373 N84740Dark River Capital LLC · Lebanon, OHBuilt 1969 · S/N 17258598 N84742Sprouse Melissa A · Greenville, PABuilt 1969 · S/N 17258599 N84748Registration Pending · Green Bay, WIRegistration pendingBuilt 1969 · S/N 17258600

Back to AD 90-06-03 R1