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.

N7183QFlying Wild LLC · Yarmouth, MEBuilt 1972 · S/N 17260483 N71844Rusinsky Michael John · Amagansett, NYBuilt 1969 · S/N 18259775 N71846C3 Aviation LLC · Eustis, FLBuilt 1969 · S/N 18259776 N7184FYoke Aviation LLC · Bowling Green, KYBuilt 1966 · S/N 15063784 N7184SCade Steven V · Lopez, WABuilt 1967 · S/N 15067884 N7185GJones Mark R · Denton, MDS/N 17258885 N71860Young Reginald L · Fort Worth, TXBuilt 1969 · S/N 18259783 N71866Lkn Skylane LLC · Mooresville, NCBuilt 1969 · S/N 18259785 N71867Friend Troy L · Wyandotte, OKBuilt 1969 · S/N 18259786 N7186SEagle Equity Inc · Valparaiso, INBuilt 1967 · S/N 15067886 N71876Rasmussen Paul · Long Lake, NYBuilt 1969 · S/N 18259788 N71879Sale Reported · Greeley, COSale reported, pending cancellationBuilt 1969 · S/N 18259789 N7187FHoranzy Paul S · N Grosvenordl, CTBuilt 1966 · S/N 15063787 N7187QChestnut Ridge Flying Club · Latrobe, PABuilt 1972 · S/N 17260487 N71880Meeks Michael D · Marion, TXBuilt 1969 · S/N 18259790 N71884Smith John L Trustee · Zephyr Cove, NVBuilt 1969 · S/N 18259792 N7188FCopeland Lance Andrew · Jacksonville, ARBuilt 1966 · S/N 15063788 N7188GVrechek Joseph D · Fort Lauderdale, FLS/N 17258888 N7188QToles Chad · Austin, TXFirst renewal noticeBuilt 1972 · S/N 17260488 N71890Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1969 · S/N 18259794 N71896Silver Eagles Flying Club Inc · Armonk, NYBuilt 1969 · S/N 18259795 N7189FTello Ricardo · Mission, TXBuilt 1966 · S/N 15063789 N7189GSky Hawk Flying Club · Grand Rapids, MNBuilt 1969 · S/N 17258889 N7189QMontgomery Paul · Fredericksburg, VABuilt 1972 · S/N 17260489 N71900Savage David E · American Falls, IDBuilt 1968 · S/N U206-1217 N7190GM T Machinery Inc · Porter, TXBuilt 1969 · S/N 17258890 N7191GHis Grace LLC · San Angelo, TXBuilt 1973 · S/N 15074621 N71924Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1968 · S/N U206-1226 N7192QMansfield Heliflight Inc · Milton, VTBuilt 1972 · S/N 17260492 N7194Ajayi Samuel O · Fredericksburg, VAS/N 15063922 N7194GAvco Patrol LLC · Lyndon, KSBuilt 1969 · S/N 17258894 N7194QOzarks Auto Show Inc · Hollister, MOBuilt 1973 · S/N 17260494 N7195FAustin Richard K · Ludington, MIBuilt 1966 · S/N 15063795 N7195GBurnside George C II · Hattiesburg, MSBuilt 1969 · S/N 17258895 N7195QPuget Sound Flyers · Everett, WABuilt 1972 · S/N 17260495 N71967Lipan Creek Flying Service LLC · Eola, TXBuilt 1969 · S/N U206-1241 N7196FStarr Benjamin M · Somerset, OHBuilt 1966 · S/N 15063796 N7196QBurdis W J · Beaver Falls, PABuilt 1972 · S/N 17260496 N7196SSale Reported · Taylorsville, MSSale reportedS/N 15067896 N7197GFly Wissota LLC · Chippewa Falls, WIBuilt 1969 · S/N 17258897 N7198FCessna Flyers LLC · Bountiful, UTBuilt 1966 · S/N 15063798 N7198GJones Lawrence A · St Simons Island, GABuilt 1969 · S/N 17258898 N7198QBay Lux Ventures LLC · Tampa, FLBuilt 1972 · S/N 17260498 N71991Bush-Tell Inc · Aniak, AKBuilt 1968 · S/N U206-1247 N71994Skydive Buckeye LLC · Goodyear, AZBuilt 1968 · S/N U206-1249 N7199FSale Reported · Pikeville, TNSale reportedBuilt 1966 · S/N 15063799 N719LCYoung Larry W · Bowdoin, MES/N 18259514 N71CPKitty Hawk Flight Training And Tours LLC · Nags Head, NCBuilt 1972 · S/N 15073229 N71ESBig Tex LLC · Reedsburg, WIS/N U206-1402 N71HHEastern Slope Aviation Academy · North Conway, NHBuilt 1971 · S/N 17260295

Back to AD 72-03-03 R3