Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N7308TBerg Weston L · Stanton, NDBuilt 1959 · S/N 46908 N73091Rudder33 LLC · Grantham, NHBuilt 1976 · S/N 17267261 N73093Yngsdal Dale A · Lino Lakes, MNBuilt 1976 · S/N 17267262 N7309TRognlie Brent R · Westminster, COBuilt 1959 · S/N 46909 N730EREmbry-Riddle Aeronautical Univeristy Inc · Prescott, AZBuilt 2023 · S/N 172S13036 N730HAHonaker Group LLC · Sellersburg, INS/N 17267246 N730LBEarly Bird Aviation LLC · Rillito, AZBuilt 1974 · S/N 17263162 N730LUTextron Aviation Inc · Wichita, KSS/N 172S13599 N73103Bfl Aviation LLC · Bakersfield, CABuilt 1976 · S/N 17267267 N73105Jlk Management LLC · Kerrville, TXBuilt 1976 · S/N 17267268 N7310GMccall Freddie W Jr · East Brewton, ALBuilt 1970 · S/N 17259010 N7310TYowell Albert W · Etlan, VABuilt 1959 · S/N 46910 N73113Top Flight Aviation Inc · Corona, CABuilt 1976 · S/N 17267269 N73116Taildraggers Flyers Inc · Saint Joseph, MIBuilt 1976 · S/N 17267272 N7312AJohnson Thomas F · Buckeye, AZS/N 29412 N7312THangar 20 Flying Club LLC · Climax, MIS/N 46912 N73131Fremont Flight Academy LLC · Fremont, OHBuilt 1976 · S/N 17267280 N73134Harborside Aviation Services Inc · Punta Gorda, FLBuilt 1976 · S/N 17267281 N7313APerkins David A · Locust Grove, OKS/N 29413 N73146Oregon State Flying Club Inc · Corvallis, ORBuilt 1976 · S/N 17267287 N73148Kinney Transportation · Columbia, MOBuilt 1976 · S/N 17267289 N73149Good Flight Aviation LLC · Stockton, CABuilt 1976 · S/N 17267290 N7314ASchultz David · Middleton, IDBuilt 1956 · S/N 29414 N7314GKittle Aviation LLC · Wichita, KSBuilt 1970 · S/N 17259014 N7314TCarney Mark A · Emporia, KSBuilt 1959 · S/N 46914 N73151Hawaii Aviators LLC · Ewa Beach, HIBuilt 1976 · S/N 17267292 N73154Bishop Services LLC · Ellisville, MSBuilt 1976 · S/N 17267293 N7316ALangley Russell M · Adair, OKBuilt 1956 · S/N 29416 N7316GCox Capital LLC · Rushville, MOS/N 17259016 N73170Jahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17267297 N73171Jettmar Rainer U · Washington, DCBuilt 1976 · S/N 17267298 N73172American Patrols Inc · Midland, TXBuilt 1976 · S/N 17267299 N73174Welch Cleatus E · Orlando, FLBuilt 1976 · S/N 17267301 N73178G P Holding Inc · Mora, MNBuilt 1976 · S/N 17267305 N73179Weengknutts 179 · Delta, UTS/N 17267306 N7317GSettles Lauren E · Owensboro, KYBuilt 1970 · S/N 17259017 N73181Nurse Alex S · San Diego, CABuilt 1976 · S/N 17267308 N73183Sandwich Aviation Inc · Somonauk, ILBuilt 1976 · S/N 17267310 N73189Ellie Air LLC · Mabank, TXBuilt 1976 · S/N 17267316 N7318GMay Curtis · Joplin, MTBuilt 1970 · S/N 17259018 N73190Flying J Enterprises LLC · San Antonio, TXBuilt 1976 · S/N 17267317 N73192Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 17267319 N73195Saratoga Flyers Inc · South Glens Falls, NYBuilt 1976 · S/N 17267322 N73197Seward Kent · Parma, IDBuilt 1976 · S/N 17267324 N73198Davis Jimmy R Jr · Wharton, TXBuilt 1976 · S/N 17267325 N73199Performance Polymer Technologies LLC · Roscommon, MIBuilt 1976 · S/N 17267326 N7319DN7319d LLC · Port Saint Lucie, FLBuilt 1979 · S/N 17272913 N7319GPiguzov Yevgeniy · Hillsborough, NJBuilt 1970 · S/N 17259019 N731TBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12573 N73200Burns Kurtis L · Clyde Park, MTBuilt 1976 · S/N 17267327

Back to AD 90-06-03 R1