Skip to content

Registered aircraft · 56,578

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N20648Jones Farm Fresh LLC · Bartlett, TNBuilt 1973 · S/N 17261460 N2064GGarcia Edward O · Hereford, AZBuilt 1958 · S/N 51364 N2064XCurtin Andrew J · Fernandina Beach, FLBuilt 1965 · S/N 18256164 N2064YRocheleau Adam A · Anchorage, AKBuilt 1962 · S/N 17249564 N20652H J H Aviation LLC · Gordo, ALBuilt 1973 · S/N 17261464 N2065GZach Matthew L · Oconomowoc, WIBuilt 1958 · S/N 51365 N2065ZBorn Stephen R · Yucaipa, CABuilt 1963 · S/N 15059865 N20660Jl Avn LLC · Ontario, OHBuilt 1973 · S/N 17261468 N20665Millais Alan K · Sacramento, CAFirst renewal noticeBuilt 1973 · S/N 17261472 N2066620666 Aircraft Leasing LLC · Spanish Fork, UTBuilt 1973 · S/N 17261473 N20667Wojtowicz Diane L · Perry, NYBuilt 1973 · S/N 17261474 N20668Safety In Motion Flight Center · Puyallup, WABuilt 1973 · S/N 17261475 N2066GLatofski-Jeffries Gustavo Enrique · Mcallen, TXBuilt 1958 · S/N 51366 N2066ZGrand Flying Club Inc · Redding, CAS/N 15059866 N20670Stearns Edwin B Jr · Eloy, AZBuilt 1973 · S/N 17261477 N20675First Flight Corp · San Diego, CABuilt 1973 · S/N 17261482 N20676Firstflight 33 LLC · Jacksonville, FLBuilt 1973 · S/N 17261483 N2067GYeager Hal J · Winterset, IAS/N 51367 N2067XPank Thomas E · Walkersville, MDBuilt 1965 · S/N 18256167 N2067YShankle Christopher · Orlando, FLBuilt 1962 · S/N 17249567 N20689Lessard Timothy F · Monmouth, MEBuilt 1973 · S/N 17261492 N2068RSix Lima Papa LLC · Kalispell, MTS/N 18255268 N2068YFurchtenicht Corey L · Sarona, WIBuilt 1962 · S/N 17249568 N2068ZThompson Jeffrey A · Bishop, CABuilt 1963 · S/N 15059868 N20693Celestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1973 · S/N 17261494 N20697Schneidman Barry · Raleigh, NCBuilt 1973 · S/N 17261496 N2069RLazy T Aviation LLC · Ashland, NES/N 18255269 N2069XFrance Frederick M · Gales Ferry, CTBuilt 1965 · S/N 18256169 N2069ZMiller Scott A · Norwood, MOBuilt 1963 · S/N 15059869 N206ARCanoe Bay Outfitters LLC · Port Alsworth, AKBuilt 1978 · S/N U20604766 N206AYOno Yutaka · Torrance, CABuilt 1967 · S/N U206-0820 N206BABoeing Company · Mesaon, AZBuilt 1973 · S/N U20602034 N206BCSkelton Thomas N · Madison, MSBuilt 1999 · S/N 20608025 N206BLWright Kim B · Anchorage, AKBuilt 1979 · S/N U20605491 N206BRWest Matthew Shawn · Island, KYBuilt 1981 · S/N U20606350 N206BSBlue Star Gas Fleet Services Co · Central Point, ORBuilt 1968 · S/N P206-0434 N206CGSmalley Glen E · Kasilof, AKS/N P206-0136 N206CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 20608227 N206CTDe Creeft Joseph M · Homer, AKBuilt 1981 · S/N U206-06090 N206DP W Feenstra Construction Inc · Queen Creek, AZBuilt 1978 · S/N U20604415 N206DCAri Air LLC · Anchorage, AKBuilt 1976 · S/N U20603198 N206DJAlum I Tank Inc · Harvard, ILBuilt 1963 · S/N 206-0055 N206DMBushwood Air LLC · Coeur D Alene, IDBuilt 1976 · S/N U20603512 N206DZEvans David J · Parker, COS/N 206-0185 N206EJSzymanski Collin Andrew Sr · Anchorage, AKBuilt 1974 · S/N U20602507 N206EKKoch & Koch Inc · Grass Valley, CABuilt 1981 · S/N U20606291 N206ELAir Tuna LLC · Homestead, FLS/N U20604037 N206EZHottois Scott · Whittemore, MIBuilt 1964 · S/N 2060048 N206FMoreau Aviation LLC · Wasilla, AKBuilt 1975 · S/N U20603015 N206FLRegistered aircraftBuilt 1978 · S/N U20604627

Back to AD 79-10-14 R1