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.

N7041GJohnson Justin Eric · Grand Forks, NDBuilt 1969 · S/N 17258741 N7041QElizabeth City State University · Elizabeth City, NCBuilt 1971 · S/N 17260341 N7041SMaclean John A · Glenview, ILBuilt 1967 · S/N 15067741 N7042FKadlecovic Martin · Prescott, AZS/N 15063642 N7042G7042g LLC · Shingle Springs, CAS/N 17258742 N7042QWatts Ruiz LLC · Waco, TXBuilt 1971 · S/N 17260342 N7042SNuernberger Howard P · State College, PABuilt 1967 · S/N 15067742 N7043QNelson Christopher J · Hayfield, MNBuilt 1971 · S/N 17260343 N7043SBaughman Jeffrey S · Keller, TXBuilt 1967 · S/N 15067743 N7044FHanson Mike D · Vinton, IABuilt 1966 · S/N 15063644 N7044GSpitzbart David G · Woodstock, ILBuilt 1969 · S/N 17258744 N7045SDiblasi Francis L · Shelton, CTBuilt 1967 · S/N 15067745 N7047FVanderlei Lowell B · Springfield, SDBuilt 1966 · S/N 15063647 N7047SHaley William R III · Carrollton, GABuilt 1967 · S/N 15067747 N7048QFirelight Academy LLC · Brush, COBuilt 1972 · S/N 17260348 N7049GLouisville Aircraft Leasing LLC · Louisville, KYS/N 17258749 N7049QVortex Aero LLC · Lakeland, FLBuilt 1972 · S/N 17260349 N7050GAircraft Management Group Inc · Honolulu, HIBuilt 1969 · S/N 17258750 N7050QMindy Limited LLC · Muscatine, IABuilt 1972 · S/N 17260350 N7050SGrizzle Jason · Roscoe, TXBuilt 1967 · S/N 15067750 N70511Tanner Carlton · Coupland, TXBuilt 1968 · S/N 18259282 N70513Hummer Ernest · Bonner, MTBuilt 1968 · S/N 18259284 N70517Southern Aviation LLC · Griffin, GABuilt 1968 · S/N 18259285 N7051GWein Greggory J · Convoy, OHBuilt 1969 · S/N 17258751 N7051QBright Flight Aviation Inc · Jacksonville, FLBuilt 1972 · S/N 17260351 N70521Gray John R · Cornville, AZBuilt 1968 · S/N 18259287 N7052GG&H Aviation · Louisville, KYBuilt 1969 · S/N 17258752 N7052QHoloman T Michael · New Smyrna Beach, FLBuilt 1972 · S/N 17260352 N70538Nordic Air LLC · Buffalo, MNS/N 18259293 N7053FAce Aeromotive Inc · Miami, FLS/N 15063653 N7053GSpare Change Enterprises LLC · Atlantic, IABuilt 1969 · S/N 17258753 N7053QCabrie Aviation Inc · Charlotte, NCBuilt 1972 · S/N 17260353 N70541Cl Finney Aviation LLC · Benton, KSBuilt 1969 · S/N 17258757 N7055QSeagraves Brad J · Rockwell, NCBuilt 1972 · S/N 17260355 N70560Blue Sky Flyers LLC · Toccoa, GAS/N 18259304 N70563Missouri-Stone Co · Cartwright, NDBuilt 1968 · S/N 18259305 N70565Langworthy Peter B · Warrensburg, MOBuilt 1968 · S/N 18259306 N70566Twin Otter International Ltd · Las Vegas, NVBuilt 1968 · S/N 18259307 N7056QFleeman Joseph R · Lawrenceburg, TNBuilt 1972 · S/N 17260356 N70574Blue Sky Pilots Inc DBA · Salem, ORBuilt 1968 · S/N 18259310 N7057QMindy Limited LLC · Muscatine, IAS/N 17260357 N70582Goos Aviation LLC · Meridian, IDBuilt 1968 · S/N 18259312 N7058FTechnical Education Services Inc · Virginia Beach, VAS/N 15063658 N7058GDc Aerial Photos Inc · Fredericksburg, VABuilt 1969 · S/N 17258758 N70591Fugleberg Richard H · Mayville, NDBuilt 1968 · S/N 18259315 N7059GFrank Todd E · Corsicana, TXBuilt 1969 · S/N 17258759 N705TDFlight Gear Aviation LLC · Pickerington, OHS/N 15069561 N70607Walsh Dennis A · Dakota City, NEBuilt 1968 · S/N 18259323 N70609Gospel Ministries International · Mc Donald, TNBuilt 1968 · S/N 18259325 N7060QPilot In Command Academy Inc · Miami, FLBuilt 1972 · S/N 17260360

Back to AD 72-03-03 R3