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.

N6889RShelton L Wayne · Rifle, COBuilt 1967 · S/N T210-0289 N6899BCowgill Robert W · Amissville, VABuilt 1978 · S/N 21062852 N68BMDavenport Donald · North Las Vegas, NVBuilt 1977 · S/N 21062441 N68MGDreger Dean R · Wilbur, WABuilt 1981 · S/N 21064392 N68NQRounds Dana H · Vacaville, CABuilt 1976 · S/N U20603399 N68TBSmith Ronald A · Los Gatos, CABuilt 1981 · S/N 21064492 N6900XMueller Robert C · Reno, NVBuilt 1977 · S/N 21062392 N6901RFritz Douglas R · Anacortes, WABuilt 1967 · S/N T210-0301 N6909RMitchell Greg · Pecos, TXBuilt 1967 · S/N T210-0309 N6910RDirty Birdy Aviation LLC · Silt, COBuilt 1967 · S/N T210-0310 N6924RTurbo Centurion LLC · Vail, AZBuilt 1967 · S/N T210-0324 N6925RDelong Mark B · Rock Springs, WYBuilt 1967 · S/N T210-0325 N6927BKryptonite Industries LLC · Golden, COBuilt 1978 · S/N 21062853 N6927RSavord George Kevin · Boulder City, NVBuilt 1967 · S/N T210-0327 N6929RShelfer Douglas · Arlington, TXBuilt 1967 · S/N T210-0329 N6931RFender Darrell L · Garfield, WABuilt 1967 · S/N T210-0331 N6932RBoxwell Avionics · Green Cove Springs, FLS/N T210-0332 N6936RKingrey William S III · Richmond, TXBuilt 1967 · S/N T210-0336 N6939NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1978 · S/N 21063161 N6939RGalloway Kyle J · Bradshaw, NEBuilt 1967 · S/N T210-0339 N6944RSilcox Cleven L · Sapulpa, OKBuilt 1968 · S/N T210-0344 N6945RDonham William David · Odessa, TXS/N T210-0345 N6946RGrosslight Gordon · Westcliffe, COBuilt 1968 · S/N T210-0346 N6949RElyan Aviation Inc · Palm Springs, CABuilt 1968 · S/N T210-0349 N6967NSand Creek Oil & Gas Inc · Edmond, OKBuilt 1979 · S/N 21063177 N6969YTorres Charles O · Riverside, CABuilt 1966 · S/N T210-0150 N6970NSeitz Thomas J · Mission, KSFirst renewal noticeBuilt 1979 · S/N 21063179 N6972NEnns Robert B · Cayucos, CABuilt 1979 · S/N 21063181 N6976NCenturion Capital Partners LLC · Blue Ash, OHBuilt 1979 · S/N 21063185 N6977BCollins Kevin T · Roseville, CABuilt 1978 · S/N 21062862 N6979NArango Jorge · Mcallen, TXBuilt 1979 · S/N 21063188 N6980MPetumenos Timothy James · Anchorage, AKBuilt 1977 · S/N 21062005 N6993NSp Aircraft LLC · Moscow, IDBuilt 1979 · S/N 21063202 N699EEMathes Jay B · Ridgecrest, CABuilt 1976 · S/N 21061184 N69LEEle Motorsports LLC · Dover, DES/N 21062897 N69PRAero Inventory LLC · Monroe, GAS/N T210-0321 N69WAKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1982 · S/N 21064707 N6DEE & R Properties Of Florence LLC · Ridgeway, SCBuilt 1978 · S/N 21062802 N6HGBagwell Harold G · Garner, NCBuilt 1978 · S/N 21062624 N7000KCohen Phillip A · Hopkinton, MABuilt 1978 · S/N 210-62553 N7000LHalstead Michael J · Gresham, ORBuilt 1975 · S/N U20602907 N701MDDel Mar Aviation LLC · Algona, IABuilt 1980 · S/N 21064007 N701PSLucky US LLC · Merrill, WIBuilt 1977 · S/N 21062339 N702TCSykes Gregory P · Arlington, WAFirst renewal noticeBuilt 1976 · S/N 21061672 N70570Miel Del Rio Grande Inc · Monte Vista, COBuilt 1973 · S/N U20602083 N70595Lung Aerial Group Inc · Tustin, CABuilt 1973 · S/N U20602085 N710TDDuke Ray J · Oak Point, TXBuilt 1976 · S/N 21061424 N711TWMartens Ruth C · Wheaton, ILBuilt 1978 · S/N 21062654 N713MATraining Wheels & Advanced Technologies LLC · La Salle, COBuilt 1966 · S/N U206-0679 N713TGSelway Construction Group LLC · Moscow, IDBuilt 1979 · S/N U20605218

Back to AD 71-09-07 R1