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.

N7758GGallo Enterprises Inc · Wonder Lake, ILBuilt 1970 · S/N 17259458 N7758TWorringer Richard G · Tower, MNBuilt 1960 · S/N 47358 N7758XHewitt Chad R · Vernonia, ORS/N 17248258 N7759TMartin Douglas A · Bartlett, ILBuilt 1960 · S/N 47359 N7759UButts Alex D · Douglassville, PABuilt 1964 · S/N 17251759 N775GTToole Gregory Keith · Humble, TXBuilt 1977 · S/N 17268509 N775LAColumbia Leasing LLC · Hillsboro, ORBuilt 2024 · S/N 172S13121 N775MCAmerican Patrols Inc · Midland, TXBuilt 1975 · S/N 17265008 N775RTG & M Aircraft Inc · Wheat Ridge, COS/N 17273352 N775SP775sp LLC · Blaine, MNBuilt 2001 · S/N 172S8705 N7760GLeriche Nicolette · Oceanside, NYBuilt 1970 · S/N 17259460 N7760UScott Timothy E · West Danville, VTBuilt 1964 · S/N 17251760 N7762TLisle Rachel C · New Enterprise, PABuilt 1960 · S/N 47362 N7762XRodriguez Bruno · Crestview, FLBuilt 1961 · S/N 17248262 N7763TWood Pro Ventures LLC · Justiceburg, TXBuilt 1960 · S/N 47363 N7764GTriad Aviation Academy LLC · Greensboro, NCBuilt 1970 · S/N 17259464 N7764XMalcolm Ward A · Moorefield, WVBuilt 1960 · S/N 17248264 N7765GJefferies Stanley J · Coos Bay, ORBuilt 1970 · S/N 17259465 N7765TWhisman Marc K · Long Beach, CABuilt 1960 · S/N 47365 N7766GAir Ally Asset Management LLC · Chisago City, MNS/N 17259466 N7766TGourley Steven E · Unionville, MOBuilt 1960 · S/N 47366 N7767GPerformance Aviation LLC · Fort Myers, FLBuilt 1970 · S/N 17259467 N7767TVisscher Paul J · Madison, GABuilt 1960 · S/N 47367 N7769TWhiskey Tango Foxtrot Aviation LLC · Bemidji, MNBuilt 1960 · S/N 47369 N776AASolo Aircraft Rental LLC · Farmingdale, NYBuilt 2005 · S/N 172S9928 N776MWAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13475 N776SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12444 N776VB40ac LLC · Hartford, WIBuilt 2000 · S/N 172S8508 N7770ASampson Zachary J · New Braunfels, TXS/N 17252309 N7770GMyers Keith R Trustee · Fond Du Lac, WIBuilt 1970 · S/N 17259470 N7770TShinn William D · Milton, WABuilt 1960 · S/N 47370 N7770UBrown Michael E · Miramar, FLBuilt 1964 · S/N 17251770 N7771BBeam Thomas W · Paw Paw, MIBuilt 1964 · S/N 17251607 N7771GEmpire Aero Club Inc · Sebastopol, CABuilt 1970 · S/N 17259471 N7771TBailey Bradley E · Phoenix, AZBuilt 1960 · S/N 47371 N7771UPryor Isaac L · Charlotte, NCBuilt 1964 · S/N 17251771 N7772GWings Over Texas Holdings LLC · Denton, TXBuilt 1970 · S/N 17259472 N7772UKiger Aviation LLC · Corvallis, ORBuilt 1964 · S/N 17251772 N7772XPremier Air Inc · Raceland, LABuilt 1961 · S/N 17248272 N7773TBennett Kevin S · Bay City, ORBuilt 1960 · S/N 47373 N7773UWitsberger Kelly R · Newburg, MOBuilt 1964 · S/N 17251773 N7774ASaydun LLC · Richardson, TXBuilt 1964 · S/N 17252168 N7774GElliott Miles · Porterville, CABuilt 1970 · S/N 17259474 N7775GMondragon Vidahk D · Reseda, CAFirst renewal noticeBuilt 1970 · S/N 17259475 N7775TSheaffer Hayden L · Lititz, PABuilt 1960 · S/N 47375 N7776GGulf Atlantic Airways Inc · Gainesville, FLBuilt 1970 · S/N 17259476 N7776XVista I Inc · Smithville, OHBuilt 1961 · S/N 17248276 N7777CSouthern Sky LLC · Henderson, NVBuilt 1976 · S/N 17267334 N7778UAngel Del Mar LLC · Park City, UTBuilt 1964 · S/N 17251778 N777AHJarhead Aviation LLC · Port Saint Lucie, FLBuilt 1973 · S/N 17261695

Back to AD 90-06-03 R1