Skip to content

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N6505MUrrea Hugo Edmundo Rincon · Katy, TXBuilt 1980 · S/N 15284760 N6505N3c3 Aviation Inc · Dania Beach, FLBuilt 1979 · S/N 21063075 N6505UBell Keith O · Navarre, FLBuilt 1962 · S/N 2259 N65065Angel Aviation Inc · Peoria, AZBuilt 1982 · S/N 17275681 N6506DWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTBuilt 1979 · S/N 17272835 N6506GWestern Skyways Inc · Montrose, COS/N 21064406 N6506ULambert Isabelle O · El Paso, TXBuilt 1962 · S/N 2260 N6507UBovey Dominic C · Sandpoint, IDBuilt 1962 · S/N 2261 N6508HBkb Inc · Newport, MIBuilt 1975 · S/N 17265469 N6508KTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274205 N6509GMehling Robert C · Hardin, MTS/N 18801202 N6509HSale Reported · Benton, KSSale reportedBuilt 1975 · S/N 17265470 N6509LSnohomish Flying Service Inc · Snohomish, WABuilt 1980 · S/N 15284425 N650VVMindy Limited LLC · Muscatine, IABuilt 1969 · S/N 17258561 N65107Renforth Michael E · Yorktown, VABuilt 1982 · S/N 17275686 N65112Jav Air Services LLC · Anchorage, AKS/N 17275688 N6511GBuerk James R · Smethport, PABuilt 1979 · S/N 17273603 N6511VSc Skywalker Aviation LLC · West Sacramento, CABuilt 1980 · S/N 172RG0741 N6512DCajun Wings LLC · Bourg, LABuilt 1979 · S/N 17272836 N6512HOrganization Of Black Aerospace Professionals Inc · Olive Branch, MSBuilt 1975 · S/N 17265471 N6512KLoomis Aviation LLC · Columbus, OHBuilt 1980 · S/N 17274206 N6512UWilliams Larry M · Midland, NCBuilt 1962 · S/N 2266 N6513DGhia Flying Venture LLC · Scottsdale, AZBuilt 1979 · S/N 17272837 N6513UKendall Keven S · Logan, UTBuilt 1962 · S/N 2267 N6514JJuggernautaviation LLC · Lewes, DEBuilt 1980 · S/N 17273880 N6515UFuller Spencer A · Lake Balboa, CABuilt 1962 · S/N 2298 N6516HArmenta Javier · Douglas, AZBuilt 1979 · S/N 15284175 N6517APeterson Holding Co · San Leandro, CABuilt 1979 · S/N 21063541 N6517DSlaboszewski Donald W Jr · Joliet, ILS/N 17272839 N6517UNova Accounting LLC · Herndon, VABuilt 1962 · S/N 2300 N65180Mccraw Bryan · Telephone, TXBuilt 1982 · S/N 17275702 N6518UWhetzel Peter W · Mathias, WVS/N 2301 N65191Bampton Dennis · Portage Des Sioux, MOBuilt 1982 · S/N 17275705 N65192Tactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 1982 · S/N 17275706 N65197Aviator Education LLC · Greeley, COBuilt 1972 · S/N 17275707 N65199Long Island Aviators LLC · Seaford, NYBuilt 1980 · S/N 15284323 N6519ABreen Jerry P III · Center Point, TXBuilt 1979 · S/N 21063542 N6519JDms Defense LLC · Annapolis, MDBuilt 1980 · S/N 17273882 N6519USherr Steven · Mandan, NDBuilt 1962 · S/N 2302 N651DMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 1325-2002 N651ECEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700633 N651RKChristensen Nathan · Newnan, GABuilt 1968 · S/N 680125 N6520ULundquist Justin Carl · Sarasota, FLBuilt 1962 · S/N 2303 N6521DWaade Odd · Bellingham, WABuilt 1979 · S/N 17272842 N6521QAlpha Wings Inc · Willoughby, OHBuilt 1981 · S/N 15285266 N65221Wings Over Texas Holdings LLC · Denton, TXBuilt 1982 · S/N 17275711 N6522RKnot Ventures LLC · Kalispell, MTBuilt 1979 · S/N 172RG0191 N6523DAir Shares LLC · Casper, WYBuilt 1979 · S/N 17272844 N6523VReal Jonathan D · Kamuela, HIBuilt 1980 · S/N 172RG0749 N6524DZuckerman Zvi A · Boardman, OHBuilt 1979 · S/N 17272845

Back to AD 80-25-07 R1