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.

N21212Sale Reported · Phoenix, AZSale reported, canceledBuilt 2007 · S/N 172S10441 N2121FSouth Dakota State University · Brookings, SDBuilt 2007 · S/N 172S10437 N2121YMclanahan John P · Culpeper, VABuilt 1963 · S/N 17249621 N2122MHalsted Aviation LLC · West Chicago, ILBuilt 2007 · S/N 172S10442 N21237Parker Jeff · Chelsea, ALBuilt 1974 · S/N 17263911 N21246Eastern Stearman Inc Trustee · Leesburg, VAS/N 17263914 N21249Western Kentucky Petroleum Inc · Osage Beach, MOS/N 17263916 N2125MNfh Aviation LLC · Pikeville, KYBuilt 2000 · S/N 17280905 N2125YPalmer Ronald Everett Trustee · Sonoma, CABuilt 1962 · S/N 17249625 N21263Suburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9429 N2126FVista Aviation Inc · Pacoima, CABuilt 2007 · S/N 172S10458 N21272Eagle Aviation Inc · Tucson, AZBuilt 1974 · S/N 17263920 N21276Schrager Daniel L Trustee · Concord, MABuilt 2003 · S/N 172S9433 N21289High Flight Academy LLC · Allison Park, PABuilt 1974 · S/N 17263923 N2128EFly For Fun LLC · Rockville, MDBuilt 1978 · S/N 17271165 N21295Tauscher Robert C · Friday Harbor, WABuilt 1974 · S/N 17263925 N2129CFlot Group LLC · Apex, NCBuilt 2003 · S/N 172S9436 N2129JRidgeline Assets LLC · Wilmington, DEBuilt 2003 · S/N 172S9441 N2129YEdwards Air LLC · Raleigh, NCBuilt 1962 · S/N 17249629 N212ANCalifornia In Nice Inc · San Jose, CABuilt 1981 · S/N 17274432 N212BGRegistered aircraftBuilt 1980 · S/N 172RG0195 N212BSEuros Aircraft Leasing LLC · College Station, TXBuilt 1999 · S/N 172S8243 N212CFWest Coast Equipment Leasing LLC · Englewood, COBuilt 1998 · S/N 17280418 N2130FSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2003 · S/N 172S9419 N21320Diehl Rodney L Trustee · San Jose, CABuilt 1974 · S/N 17263929 N21321Bell Robert A · Las Vegas, NVBuilt 1974 · S/N 17263930 N21329Propeller Enterprises LLC · Gilbert, AZBuilt 1974 · S/N 17263931 N2132WWheeler Equipment Leasing LLC · Gainesville, GABuilt 2003 · S/N 172S9421 N21339Pilots Flying School LLC · Englishtown, NJBuilt 2003 · S/N 172S9551 N2133YBullock John E Jr · Birdseye, INBuilt 1962 · S/N 17249633 N21347Kessler Frank J Jr · Gallatin, TNBuilt 1974 · S/N 17263933 N2134MChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9552 N2134YHi Line Flying Club Inc · Seattle, WABuilt 1962 · S/N 17249634 N21351Midwest Flying Service LLC · Wilmington, DEBuilt 1974 · S/N 17263934 N2135KJet Air Inc · Iowa City, IABuilt 2003 · S/N 172S9556 N2135SEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2003 · S/N 172S9558 N21360Weede Roger H · Dubois, WYS/N 17263935 N21374Stratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263938 N2137YCullinan David · Fryeburg, MEBuilt 1962 · S/N 17249637 N21389Registration Pending · Waldo, WIRegistration pendingBuilt 1974 · S/N 17263942 N2138WChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9561 N21394Long Island Aviators LLC · Seaford, NYBuilt 2007 · S/N 172S10449 N2139UJust Plane Stuff Inc · Jackson, MSBuilt 2007 · S/N 172S10448 N213AAAir Mac Ventures LLC · Houston, TXBuilt 2007 · S/N 172S10511 N213ANCalifornia In Nice Inc DBA · San Jose, CAS/N 17272380 N213NBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12572 N21403Bering Capital LLC · Anchorage, AKBuilt 1974 · S/N 17263944 N2140JHardin County Aviation LLC · Kountze, TXBuilt 1975 · S/N 17265018 N2141YAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 172S9562 N21446Ham Todd O · Opdyke, ILBuilt 1974 · S/N 17263946

Back to AD 90-06-03 R1