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.

N73199Performance Polymer Technologies LLC · Roscommon, MIBuilt 1976 · S/N 17267326 N7319DN7319d LLC · Port Saint Lucie, FLBuilt 1979 · S/N 17272913 N7319GPiguzov Yevgeniy · Hillsborough, NJBuilt 1970 · S/N 17259019 N7319TAlberta Aviation LLC · Wyoming, MIBuilt 1977 · S/N R18200028 N7319XHays Software Development LLC · Timnath, COBuilt 1977 · S/N R18200075 N731ABA & C Ag Aviation Inc · Unadilla, GABuilt 1976 · S/N 18802735T N731BGKutschera Theodore C DBA · Callicoon, NYBuilt 1976 · S/N 18802763T N731BJArmis Strategies LLC · Hartwell, GABuilt 1979 · S/N P21000437 N731BMBenaiah Holdings Corp · Marion, KYS/N 18802768T N731CBAnesthesia Aviation LLC · Leesburg, VAS/N P21000545 N731CENoe Aviation LLC · Vinton, IABuilt 1976 · S/N 18802785T N731CQD & K Aviation Inc · Milford, IABuilt 1977 · S/N 18802794T N731CYSan Diego Air Service · San Diego, CABuilt 1979 · S/N P21000442 N731DSYou And Me LLC · Sedalia, MOBuilt 1979 · S/N P21000446 N731ECFitchett Bradley S DBA · Ellsworth, KSS/N 18802830 N731EQUnited States Department Of Agriculture · Edinburg, TXBuilt 1976 · S/N 18802843T N731ESSky Tech Inc · Dorchester, NES/N 18802845T N731FEJones Marilyn W · Collinsville, CTBuilt 1979 · S/N P21000450 N731FKQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N P21000452 N731FMNew Frontier Aviation LLC · Fort Benton, MTBuilt 1977 · S/N 18802862T N731FPLihs Ryan J · Sioux City, IABuilt 1977 · S/N 18802864T N731FTMillican Clifford A · Burleson, TXBuilt 1979 · S/N P21000454 N731GCLavalley Asset Management Inc · Potsdam, NYBuilt 1979 · S/N P21000457 N731GDRegistration Pending · Walnut, ILRegistration pendingBuilt 1977 · S/N 18802877T N731GPUpshaw John L Jr · Claude, TXBuilt 1977 · S/N 18802887T N731GTDigger Dougs Crop Dusting Services Inc · Hollandale, WIBuilt 1977 · S/N 18802891T N731HRBrennan Timothy · San Francisco, CABuilt 1980 · S/N P21000464 N731HTAeolus Aviation LLC · Franklin, TNBuilt 1980 · S/N P21000465 N731HWOne Hotel Whskey LLC · Hugoton, KSBuilt 1980 · S/N P21000468 N731HYM&S Equipment Leasing LLC · Dalhart, TXS/N P21000470 N731JDReifschneider Harry III · Mesa, AZBuilt 1977 · S/N 340-77 N731JGGate Air LLC · Ketchum, IDBuilt 1980 · S/N P21000474 N731JXKai Herbert DBA · Rillito, AZFirst renewal noticeS/N P21000479 N731KLMullen James P Jr · Rogers, ARS/N P21000483 N731KMMartin Rick H · Las Vegas, NVS/N P21000484 N731KWVann Dudley C DBA · Greenville, NCBuilt 1977 · S/N 18802963T N731LACmk Aerial Inc · Sutton, NEBuilt 1977 · S/N 18802967T N731LFMcneill Dudley T · Happy, TXS/N 18802972 N731LNEastern Washington Ambulatory Anesthesia Svcs Pllc · Walla Walla, WABuilt 1980 · S/N P21000488 N731LTDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N P21000436 N731LUDiversified Air LLC · Kalispell, MTBuilt 1980 · S/N P21000490 N731MKMccormick Eugene C DBA · Tyler, ALS/N 18802999T N731MQClassic Management Corp · Marion, INBuilt 1980 · S/N P21000496 N731MRMerced County Mosquito Abatement District · Merced, CAS/N 18803005T N731NCSmith Bryan · Wenatchee, WABuilt 1980 · S/N P21000502 N731NRWife Approved LLC · Torrance, CABuilt 1980 · S/N P21000509 N731NUNgu Services LLC · Sheridan, WYBuilt 1980 · S/N P21000512 N731NXCarey Richard · Dallas, TXBuilt 1980 · S/N P21000515 N731NZWoodgrain Millwork Transportation LLC · Fruitland, IDBuilt 1980 · S/N P21000517 N731PDInvisible Angels · Washington, DCBuilt 1980 · S/N P21000519

Back to AD 80-25-07 R1