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.

N8062EAviation Specialized Services LLC · Lewisville, TXS/N 17272123 N8062XHerring Fred A · Walnut Ridge, ARBuilt 1961 · S/N 17248562 N80635Clements Calvin · Palmyra, PABuilt 1976 · S/N 17266683 N80636Walls George H · Matthews, NCBuilt 1976 · S/N 17266684 N80641Missionary Flight Training Inc · Fort Pierce, FLBuilt 1976 · S/N 17266686 N80643Santa Barbaara Flying Club · Goleta, CABuilt 1976 · S/N 17266687 N8064BCarrison Harold F · Pleasanton, CABuilt 1957 · S/N 29864 N8064LMccormick Michael P · Durham, NCBuilt 1967 · S/N 17256264 N80657Shelburne Airport Inc · Shelburne, VTBuilt 1976 · S/N 17266693 N8065LDream Big Aviation LLC · Mount Juliet, TNS/N 17256265 N8065XCollege Of Missionary Aviation Inc · Keystone Heights, FLBuilt 1961 · S/N 17248565 N80669Buchert Barbara K · Shrewsbury, MABuilt 1976 · S/N 17266696 N80670Jb Aviation Management Inc · Wonder Lake, ILBuilt 1976 · S/N 17266697 N80673Mitchell Aviation LLC · Mitchell, SDBuilt 1976 · S/N 17266698 N80678Aero Maintenance Inc · Vancouver, WABuilt 1976 · S/N 17266699 N8067BReynolds Ronnie · White Hall, ARBuilt 1957 · S/N 29867 N8067LAviation Guys LLC · Charleston, WVBuilt 1967 · S/N 17256267 N8067XCowan Norman · Tallapoosa, GABuilt 1961 · S/N 17248567 N8068LMason David M · Destin, FLBuilt 1967 · S/N 17256268 N8068XBurns Shawn P · Holly Ridge, NCBuilt 1961 · S/N 17248568 N80692Registered aircraftBuilt 1976 · S/N 17266703 N80697Moe-Air LLC · Cincinnati, OHBuilt 1976 · S/N 17266705 N8069BFailmezger Robert A · Fulton, NYBuilt 1957 · S/N 29869 N806DAPeak Leasing LLC · Anchorage, AKBuilt 1977 · S/N 17270154 N806HAFlywell Aviation LLC · Bowling Green, KYBuilt 1976 · S/N 17266669 N806JTR&L Aviation LLC · Kansas, OKBuilt 1964 · S/N 17251200 N806SPAir Marion Inc · Marion, INBuilt 1999 · S/N 172S8110 N80700Changes In Latitude LLC · Kingwood, TXBuilt 1976 · S/N 17266706 N8070BFlybravo LLC · Jasper, TXBuilt 1957 · S/N 29870 N8070XPreble Thomas A · Peyton, COBuilt 1961 · S/N 17248570 N80725High Flight Academy LLC · Allison Park, PAS/N 17266716 N80729Poon Tsui P · Rosemead, CABuilt 1976 · S/N 17266719 N8072LBobo Jason A · Lampasas, TXBuilt 1967 · S/N 17256272 N80734Tipps Robert J Jr · Port Aransas, TXBuilt 1976 · S/N 17266721 N80735S & S Aircraft Inc · El Dorado, ARFirst renewal noticeBuilt 1976 · S/N 17266722 N8073BSachs James B · Rochester, NYBuilt 1957 · S/N 29873 N8073EOcean Aviation Inc · Berlin, MDBuilt 1978 · S/N 17272129 N80742Elliott Richard D · Castle Rock, WABuilt 1976 · S/N 17266726 N8074BGraziano Thomas K · Benson, AZBuilt 1957 · S/N 29874 N8074EN8074e LLC · Jackson, NJS/N 17272130 N8074XDockins Jamie L · Athol, IDS/N 17248574 N80751Haaland Karlyle R · Dalhart, TXBuilt 1976 · S/N 17266728 N80759Leaseair LLC · Wilmington, DES/N 17266733 N8075BAverett Joseph B · Denham Springs, LABuilt 1957 · S/N 29875 N80764Mcneill Jim R · Wichita, KSBuilt 1976 · S/N 17266735 N80767Ainsworth Martha Trustee · Bowie, MDBuilt 1976 · S/N 17266737 N8076BZurinsky Richard · Port Orchard, WABuilt 1957 · S/N 29876 N8076LWay Properties LLC · Tumbling Shoals, ARS/N 17256276 N80773Boyl Traci L · Ukiah, CABuilt 1976 · S/N 17266740 N80774Dugger Aviation LLC · Merritt Island, FLBuilt 1976 · S/N 17266741

Back to AD 90-06-03 R1