Skip to content

Registered aircraft · 1,686

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:71-09-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:71-09-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:71-09-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:71-09-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:71-09-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:71-09-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.

N7576NHusum Charles · Redmond, WABuilt 1977 · S/N U20603683 N75773Dena'Ina Leasing Agency LLC · Anchorage, AKBuilt 1980 · S/N 20700643 N7584NCarto Flight Inc · Willoughby, OHBuilt 1977 · S/N U20603689 N75870Westwind Aviation Inc · Phoenix, AZBuilt 1980 · S/N 20700648 N7590NIventosch Leonard · Mccall, IDBuilt 1977 · S/N U20603694 N7591NJones Michael D · Southern Pines, NCBuilt 1979 · S/N 21063240 N75935Allison Aviation LLC · Missoula, MTBuilt 1975 · S/N 21060741 N7594MNcneill Dudley · Happy, TXBuilt 1977 · S/N 21062025 N7599NAir Conejos Inc · El Paso, TXBuilt 1979 · S/N 21063243 N75DAHenderson John L · Ozona, TXBuilt 1979 · S/N 21063172 N75DMPro-Rentals Inc · Athens, OHBuilt 1976 · S/N 21061430 N75GLSkyshare LLC · Boulder, COBuilt 1973 · S/N 21059814 N75RCJoffe Zalman · Bahama, NCBuilt 1981 · S/N 21064325 N7600NKeller Douglas O · West Linn, ORBuilt 1977 · S/N U20603704 N7610CSawtooth Flying Service Inc · Mccall, IDBuilt 1977 · S/N U20603924 N7610MEickhoff Steven M · Fountain, MNBuilt 1977 · S/N 21062030 N761BDRockwell Richard E · Aledo, TXBuilt 1977 · S/N 21062118 N761BLLong Ernest D · Trabuco Canyon, CABuilt 1977 · S/N 21062125 N761BVN761bv LLC · Sioux Falls, SDBuilt 1977 · S/N 21062134 N761BYB&E Leasing LLC · Dubuque, IABuilt 1977 · S/N 21062137 N761BZAltair Aircraft LLC · Gainesville, FLBuilt 1977 · S/N 21062138 N761CECharlie Echo Enterprises LLC · Cedar Hills, UTBuilt 1977 · S/N 21062143 N761CLUlrick Michael R · Spokane, WABuilt 1977 · S/N 21062149 N761CNFrance Sherrod W Trustee · Rawlins, WYBuilt 1977 · S/N 21062151 N761CTNajm Ziad · Mission Viejo, CABuilt 1977 · S/N 21062156 N761CWOne Charlie Whiskey LLC · Austin, TXBuilt 1980 · S/N 21064042 N761DHSk Sky LLC · Clint, TXBuilt 1977 · S/N 21062170 N761DLTyler David W · Glendale, AZBuilt 1977 · S/N 21062173 N761DMHudson William B L · Belvedere, CABuilt 1977 · S/N 21062174 N761DNReichman Robert T Trustee · Escondido, CABuilt 1977 · S/N 21062175 N761DPSunset Cattle Co LLC · Los Banos, CABuilt 1977 · S/N 21062176 N761DSTroutman Alan D · Springtown, PABuilt 1977 · S/N 21062179 N761DXFlying Float Club LLC · Tavares, FLBuilt 1977 · S/N 21062184 N761EUMelvey Jay R · Westminster, COBuilt 1977 · S/N 21062205 N761EWInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 21062207 N761EZState Of Arizona · Prescott, AZBuilt 1977 · S/N 21062210 N761FCFrenchman Valley Produce Inc · Imperial, NEBuilt 1977 · S/N 21062213 N761FKSunset Cattle Co LLC · Los Banos, CABuilt 1977 · S/N 21062220 N761FQBalderrama Rocio Ovando · El Paso, TXBuilt 1977 · S/N 21062225 N761GBFerguson Robert Martin Todd · Carlisle, ARBuilt 1977 · S/N 21062236 N761GETeton Leasing LLC · Pocatello, IDBuilt 1977 · S/N 21062239 N761GYOff We Go LLC · Fort Collins, COBuilt 1977 · S/N 21062257 N761HCZimmermann Fredric M · Granbury, TXBuilt 1977 · S/N 21062261 N761HEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 21062263 N761HJAmerican Aircraft Sales LLC · Lincolnshire, ILExpired dealer, pending cancellationS/N 21062267 N761HNA-1 American Fence Inc · Orange, TXBuilt 1977 · S/N 21062271 N761HSLassetair LLC · Glen Ellen, CABuilt 1977 · S/N 21062275 N761HTWieckowski Peter · Boxford, MABuilt 1977 · S/N 21062276 N761HVResultant Aviation LLC · Orlando, FLBuilt 1977 · S/N 21062278 N761JDRj Aviation LLC · Byhalia, MSBuilt 1977 · S/N 21062286

Back to AD 71-09-07 R1