Skip to content

Registered aircraft · 56,580

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.

N3079JAdvantage Aviation Services LLC · South Saint Paul, MNBuilt 1965 · S/N 15061179 N307BMBow Mac Aviation LLC · Spring Lake, MIBuilt 1973 · S/N 17262450 N307BZSummit Aviation Inc · Belgrade, MTBuilt 2003 · S/N 172S9486 N307CFSchwarzenberg Johannes · Helena, MTFirst renewal noticeBuilt 1973 · S/N 21059961 N307CREmpire Of Stars Commercial And Residential Real · Downey, CAS/N 17262385 N307GHollister Jet Center Inc · Hollister, CABuilt 1974 · S/N 17263007 N307GRJ & D Flying LLC · Sand Point, AKBuilt 1979 · S/N 18503947 N307JHRoundy Joseph · Three Forks, MTBuilt 1980 · S/N 207-00584 N307KMMcphaill Kevin · Visalia, CABuilt 1963 · S/N 17250381 N307SPSheridan Pilots 307 LLC · Sheridan, WYBuilt 1979 · S/N 17273438 N30800Congdon Carl J · Manley Hot Springs, AKBuilt 1970 · S/N 17701471 N30805Joshua Apodaca · Glendale, AZBuilt 1970 · S/N 17701474 N30807Edwards Garland U · Midlothian, VABuilt 1970 · S/N 17701476 N3080ESky Safety Inc · San Antonio, TXBuilt 1978 · S/N 17271433 N3080JShafovaloff Thomas E · Scottsboro, ALBuilt 1965 · S/N 15061180 N3080QN3080q LLC · Phoenix, AZBuilt 1967 · S/N 18258080 N3080XN3080x LLC · Greenwood Village, COFirst renewal noticeBuilt 1966 · S/N 15064480 N3080YHd Aviation LLC · Birch Tree, MOBuilt 1962 · S/N 18254080 N3081FHenion John D · Trumansburg, NYBuilt 1966 · S/N 18257181 N3081SSproul Wendell C · Hermon, MEBuilt 1967 · S/N 15066981 N30824Rude Allen · Mcville, NDBuilt 1970 · S/N 17701486 N30826Grundy James W · W Greenwich, RIBuilt 1970 · S/N 17701487 N30828Lary Leanne K · Thousand Oaks, CAS/N 17701489 N3082ACatamount Aviation Inc · Marshfield, VTBuilt 1953 · S/N 25726 N3082EAirgo Inc · Centralia, ILFirst renewal noticeBuilt 1978 · S/N 17271435 N3082FHoffman Allen C · Anchorage, AKS/N 18257102 N3082JLandrum Craig · Vinita, OKS/N 15061182 N3082QAttaalla Maged A · Torrance, CAS/N 18258082 N3082UArmstrong Geoffrey Peter · Las Vegas, NVBuilt 1963 · S/N 17250682 N3082YSappington Steven R · Redondo Beach, CABuilt 1962 · S/N 18254082 N30835Landis Wayne G · Bellingham, WABuilt 1970 · S/N 17701495 N3083AWheeler Paul E · Clayton, NMBuilt 1953 · S/N 25727 N3083FFree Richard D · Clearwater, KSBuilt 1966 · S/N 18257183 N3083SPrather David H · Gig Harbor, WABuilt 1967 · S/N 15066983 N30841Mulliken Jerry A · Nickerson, NEBuilt 1970 · S/N 17701499 N3084JDorn Caleb · Bossier City, LABuilt 1965 · S/N 15061184 N3084SHigh Exposure Inc · Wilmington, DEBuilt 1967 · S/N 15066984 N3084YWasatch Industries LLC · Ogden, UTBuilt 1962 · S/N 18254084 N30851Cohorst Jason P · Shawnee, KSBuilt 1970 · S/N 17701502 N30852Navonics Inc · Bluffton, SCBuilt 1970 · S/N 17701503 N30853Bas Part Sales LLC · Greeley, COBuilt 1970 · S/N 17701504 N30856Groothius Duane A · Rosemount, MNBuilt 1970 · S/N 17701507 N30858Freeman Anita · Marshfield, MOBuilt 1970 · S/N 17701509 N3085AMerriman Joel W · North Pole, AKBuilt 1953 · S/N 25729 N3085SVilleneuve Stephane A Peltereau · Fort Worth, TXBuilt 1967 · S/N 15066985 N3085UMoyers Tim J · Clovis, NMBuilt 1963 · S/N 17250685 N30860West Michigan Flying Club Inc · Norton Shores, MIBuilt 1970 · S/N 17701510 N30861Blake Bobby J · Eugene, ORS/N 17701511 N30866Davis Joseph G Jr · Durham, CTBuilt 1970 · S/N 17701514 N30869Hallford Aviation LLC · Cleveland, MSBuilt 1970 · S/N 17701517

Back to AD 79-10-14 R1