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.

N6246BR L Equipment And Services LLC · Monument, COBuilt 1978 · S/N 21062721 N6267YZero Four Twelve LLC · Clovis, NMBuilt 1981 · S/N 21064313 N6270XLees Robert A II · Mesa, AZBuilt 1980 · S/N U20605851 N6274AA V T210 LLC · Palmdale, CABuilt 1979 · S/N 21063517 N6276BN6276b LLC · Katy, TXS/N 21062730 N6277ZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N U20606211 N6278YTown & Country Aviation LLC · Sunnyvale, CABuilt 1981 · S/N 21064318 N6282BBig G Air LLC · Durango, COBuilt 1978 · S/N 21062735 N6285HWhitetail LLC · Anchorage, AKBuilt 1978 · S/N 20700466 N628TTTollen Troy J · Austin, TXBuilt 1978 · S/N 21063058 N6291CSatl Ranch Aviation LLC · Midland, TXBuilt 1980 · S/N 21063857 N6295YSkydoc LLC · Mokena, ILBuilt 1981 · S/N 21064322 N6297HHackbart Gary H · Las Vegas, NVBuilt 1978 · S/N 20700472 N6297YL&L Aviation LLC · Baden, PAS/N 21064323 N6299CCenturion Flight LLC · Auburn, WABuilt 1980 · S/N 21063858 N629WSPrecision Avionics Specialists · Griffin, GABuilt 1970 · S/N 21059363 N6303BUpper Valley Aero LLC · Hanover, NHBuilt 1978 · S/N 21062741 N6305UMission Aviation Fellowship · Nampa, IDS/N U20605411 N6306CLongs Air Conditioning Inc · Avon Park, FLBuilt 1980 · S/N 21063860 N6308HAmerican Aviation Inc · Page, AZBuilt 1978 · S/N 20700476 N6314CC4p LLC · Jackson, TNFirst renewal noticeBuilt 1980 · S/N 21063861 N6314DSaghafi Jamsheed Trustee · Parma, OHBuilt 1978 · S/N 21062938 N6328CArnold Aviation & Thunder Mountain Express Inc · Cascade, IDBuilt 1980 · S/N 21063865 N6328YKoehn Lacey · Van Horn, TXBuilt 1981 · S/N 21064338 N6329CUnited Indian Mission DBA · Tucson, AZBuilt 1977 · S/N U20603844 N6329YDiablo Aviation LLC · Pleasanton, CABuilt 1981 · S/N 21064339 N6339CBowles Donald E Jr · Dallas, TXBuilt 1980 · S/N 21063871 N6344YCole William G · Garner, NCBuilt 1981 · S/N 21064344 N6352ZSale Reported · Anchorage, AKSale reportedBuilt 1981 · S/N U20606250 N6355CDutch Air LLC · Kalispell, MTBuilt 1980 · S/N 21063874 N6359BRoss Stout Architect Inc · Indian Wells, CABuilt 1978 · S/N 21062749 N6362AMillican Clifford A · Burleson, TXBuilt 1979 · S/N 21063523 N6364BKgnf LLC · Grenada, MSBuilt 1978 · S/N 21062750 N6364CSukhakarta Rentals LLC · Cedar Park, TXBuilt 1980 · S/N 21063875 N6386CBas Part Sales LLC · Greeley, COS/N 21063879 N6388YMaclean Kenneth J · Northborough, MABuilt 1981 · S/N 21064359 N6391UGimli Son LLC · Fort Lauderdale, FLBuilt 1979 · S/N U20605472 N6392CTretter Nicholas · Holden, MABuilt 1980 · S/N 21063880 N6394DManzur Miguel Antonio · Mcallen, TXBuilt 1977 · S/N 21062010 N6395ZN Berk Consultant Inc · Greenwich, CTBuilt 1981 · S/N U20606266 N6397BLayson Walter E · Calhoun, GABuilt 1978 · S/N 21062758 N6397YAsher James A · Pasadena, CABuilt 1981 · S/N 21064363 N6398YSinglepoint Technologies Corp · Richmond, VABuilt 1981 · S/N 21064364 N6402NManos Con Alas Aviation · Stateline, NVBuilt 1978 · S/N 21062978 N6408NBorders Nowell W · Edinburg, TXBuilt 1978 · S/N 21062984 N6409YChino Aviation Inc · Chino, CABuilt 1981 · S/N 21064369 N6410NAerial Services Inc · Cedar Falls, IABuilt 1978 · S/N 21062986 N6417NTaylor Michael Norman · Chino Hills, CABuilt 1978 · S/N 21062993 N6419BMarshall Timothy M Trustee · Tucson, AZBuilt 1978 · S/N 21062762 N6419XPernat Frank J Trustee · Chaska, MNBuilt 1980 · S/N U20605877

Back to AD 71-09-07 R1