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.

N2152QGeorge R Jones Jr · Dallas, TXBuilt 1974 · S/N 177RG0552 N2152RRobinson Aviation LLC · Wilmington, DEBuilt 1964 · S/N 18255352 N2153CReed Matthew E · Palmerton, PABuilt 1978 · S/N 17702742 N2155QFellows Walter · Prineville, ORBuilt 1974 · S/N 177RG0555 N2155ROne Zero Four LLC · Germantown, TNBuilt 1964 · S/N 18255355 N2156QBowers Jackie M · Elmer, NJBuilt 1974 · S/N 177RG0556 N2156RWinfrey Walter A Trustee · Auburn, CABuilt 1964 · S/N 18255356 N215JInnovative Aerodynamic Technologies · Yorktown, VAS/N 21059226 N2160RPaper Plane LLC · Hotchkiss, COBuilt 1964 · S/N 18255360 N2161QSalty Dawg Aircraft Inc · Gasport, NYBuilt 1974 · S/N 177RG0561 N2161RKlemme Aviation LLC · Davenport, IABuilt 1964 · S/N 18255361 N2163RRupp Michael David · Lunenburg, MABuilt 1964 · S/N 18255363 N2165RSproket Industries Inc · Fulton, CABuilt 1964 · S/N 18255365 N2166QLiberty Partners Inc · Okmulgee, OKBuilt 1974 · S/N 177RG0566 N2166RKrom Raymond L · Brighton, MIBuilt 1964 · S/N 18255366 N2167CStarkys Equipment Leasing LLC · Manchester, MIBuilt 1978 · S/N 17702743 N2167RTake It Easy LLC · Durango, COBuilt 1964 · S/N 18255367 N2168RNd Aero Solutions LLC · Bismarck, NDBuilt 1964 · S/N 18255368 N2169CAddison Jeffery A · Lafayette, LABuilt 1978 · S/N 17702744 N2169QWhite Beth A · Keene, NHBuilt 1974 · S/N 177RG0569 N2169YRudy Jonathan E · New Cumberland, PABuilt 1967 · S/N 17256395 N216TSS&S Aircraft Inc · Bennington, VTBuilt 1968 · S/N 17256570 N2170CMendez Gary · San Pedro, CAS/N 17702745 N2170QSkowronski Steven · Demotte, INBuilt 1974 · S/N 177RG0570 N2172FAndres James E · Delaware, OHBuilt 1965 · S/N U206-0372 N2172QLehr Kenneth Edward Trustee · Sacramento, CABuilt 1974 · S/N 177RG0572 N2172RMitchell Gary · Huntsville, TXBuilt 1964 · S/N 18255372 N2173RRegistered aircraftBuilt 1964 · S/N 18255373 N2174QRothrock Brandon E · Los Angeles, CABuilt 1974 · S/N 177RG0574 N2175RHolt Kristopher T · Wichita, KSS/N 18255375 N2176CScrap Materials Inc · Huntington, ARS/N 17702746 N2176FClaw Aviation LLC · Missoula, MTBuilt 1965 · S/N U206-0376 N2176QHawkins George W IV · Kansas City, KSBuilt 1974 · S/N 177RG0576 N2177CRenaissance General Restoration Contracting · Madera, CABuilt 1978 · S/N 17702747 N2177RCalongne Michelle H · Cypress, TXS/N 18255377 N2178CHowey Paul W · Stevensville, MDBuilt 1978 · S/N 17702748 N2178R2178 Romeo LLC · Pawlet, VTBuilt 1964 · S/N 18255378 N2179FKingdom Air Corps Inc · Sutton, AKBuilt 1965 · S/N U206-0379 N2179QHuston Jeffrey D · Haslet, TXBuilt 1974 · S/N 177RG0579 N217AFSouth 40th Rentals LLC · Jamul, CAS/N 177RG1011 N217JLGallup Shelley P · Monterey, CABuilt 1971 · S/N 177RG0140 N2181FReese Percy C · Whitefish, MTS/N U206-0381 N2181ROflynn Christopher M · Woodland, WABuilt 1964 · S/N 18255381 N2182CSkyhunter LLC · Yonkers, NYS/N 17702749 N2182RFoxley Brothers · Platte, SDBuilt 1964 · S/N 18256109 N2183CVaughn Michael A Jr · Oxford, MIBuilt 1978 · S/N 17702750 N2183QMcpherson Douglas G · Pennellville, NYS/N 177RG0583 N2184FCarr Cassandra C · San Antonio, TXBuilt 1965 · S/N U206-0384 N2184QMallette Carl L · Knoxville, TNBuilt 1974 · S/N 177RG0584 N2184RHatbox LLC · Snohomish, WAS/N 18255384

Back to AD 72-03-03 R3