Skip to content

Registered aircraft · 17,027

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N7141QFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260441 N71420Yeti Aviations LLC · Madison, ALBuilt 1969 · S/N 18259616 N7142QObymachow Richard M · Killingworth, CTS/N 17260442 N7143GAllen Nathanael W · Bemidji, MNBuilt 1969 · S/N 17258843 N7144GJc Flight Inc · Wilmington, DEBuilt 1969 · S/N 17258844 N7144SLet There Be Flight LLC · Portage, MIBuilt 1967 · S/N 15067844 N71450Ejs Enterprises Inc · Three Forks, MTBuilt 1969 · S/N 18259627 N71452Blay Jeffrey E · Oak Harbor, OHBuilt 1969 · S/N 18259629 N71462Shaffer Jessie J · Peyton, COBuilt 1969 · S/N 18259632 N71463Rodrigo Jodi L · Orland, CABuilt 1969 · S/N 18259633 N7146FR And R Plane LLC · Lewiston, IDBuilt 1966 · S/N 15063746 N7146GHalladay Roy · Erie, COBuilt 1969 · S/N 17258846 N7146QPressley Aviation LLC · New London, NCBuilt 1972 · S/N 17260446 N7147FHernandez Jorge L · Luthersville, GABuilt 1966 · S/N 15063747 N7147GAffordable Flying LLC · Cedar Park, TXBuilt 1969 · S/N 17258847 N71484Noss David L Jr · Hominy, OKBuilt 1969 · S/N 18259637 N7148FHigh Flight Aviation Of Kentucky Inc · Lexington, KYFirst renewal noticeBuilt 1966 · S/N 15063748 N7148SJupiter Flight Service And Investing LLC · Lithonia, GAS/N 15067848 N71491Kelley Philip W · Titus, ALBuilt 1969 · S/N 18259641 N71494Neverland LLC · Emerson, IABuilt 1969 · S/N 18259643 N7149QS&H Aviation LLC · Columbus, INS/N 17260449 N7149SMcateer Kristy · East Greenwich, RIS/N 15067849 N714JPCp Aviation Inc · Santa Paula, CABuilt 1966 · S/N 15065030 N714TPRutherford Troy L · Clanton, ALBuilt 1965 · S/N 18256503 N7150FTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1966 · S/N 15063750 N71511Jochl Kimberley · Sugar Mountain, NCFirst renewal noticeBuilt 1969 · S/N 18259647 N71514Slater Richard · Graham, WABuilt 1969 · S/N 18259648 N71518Northern Arizona 182 Flying Guys LLC · Flagstaff, AZBuilt 1969 · S/N 18259650 N7151GRoadrunner Flight School LLC · Farmington, NMBuilt 1969 · S/N 17258851 N7152GJ&B Aircraft Leasing LLC · Lufkin, TXBuilt 1969 · S/N 17258852 N7152QSkyrealms LLC · Austin, TXBuilt 1972 · S/N 17260452 N71538Grier Curtis · Lake Havasu City, AZBuilt 1969 · S/N 18259656 N7153GEricson Eric · St Charles, ILBuilt 1973 · S/N 15074618 N7154FFenton Richard Trustee · Mckinleyville, CABuilt 1966 · S/N 15063754 N7154GJuranich William M · Kent, WAS/N 17258854 N7154SAlexander Aviation LLC · Ellisville, MSBuilt 1967 · S/N 15067854 N71551Aivcon Inc · Charlevoix, MIBuilt 1969 · S/N 18259662 N7155FJr Imaging Logistics Inc · Pasco, WABuilt 1966 · S/N 15063755 N7155QValley Ltd Of Fayetteville · Fayetteville, NCBuilt 1972 · S/N 17260455 N71560Kansas State University Parachute Club · Manhattan, KSBuilt 1969 · S/N 18259663 N71569Ziegler Andrew J · Clyde, OHBuilt 1969 · S/N 18259667 N7156QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260456 N71573Steed David A · Oklahoma City, OKBuilt 1969 · S/N 18259668 N7157GAero Quest LLC · Olive Branch, MSBuilt 1969 · S/N 17258857 N71582Papon Bruce G · Hardtner, KSBuilt 1969 · S/N 18259671 N71583Zidek Lawrence Paul · Onaga, KSBuilt 1969 · S/N 18259672 N71584Burris Joshua William · Maiden, NCBuilt 1969 · S/N 18259673 N71587Bynum Jerry R · San Angelo, TXBuilt 1969 · S/N 18259674 N71589Carr Mark F · Anchorage, AKBuilt 1969 · S/N 18259676 N7158GHawk Aviation Inc · Rush City, MNBuilt 1969 · S/N 17258858

Back to AD 72-03-03 R3