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.

N2322YIn Flight Aircraft LLC · Howell, MIBuilt 2005 · S/N 172S9985 N2323UBurch Daniel C · Oakdale, MNBuilt 1962 · S/N 17249923 N2327USprague Jeremiah A · Halfway, ORS/N 17249927 N23281Sosa Jonathan · Orlando, FLBuilt 1974 · S/N 17264082 N2328RYoung Airmans Association Inc · Arverne, NYBuilt 2005 · S/N 172S9989 N23291Oracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264083 N2329EMeshoppen Air LLC · Meshoppen, PABuilt 1978 · S/N 17271235 N232EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13095 N232FFArq Aviation LLC · Wilmington, NCBuilt 2026 · S/N 172S13571 N232LSElliott Arthur M · Portland, TXBuilt 1971 · S/N 17260131 N2330EManhattan Flying Tigers Inc · Bozeman, MTBuilt 1978 · S/N 17271236 N2330FFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9992 N2332EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271238 N2334GHegna David E · Wall Township, NJBuilt 2005 · S/N 172S9994 N2334JThree Four Juliet LLC · Orange, CABuilt 2005 · S/N 172S9995 N2334USimplifly LLC · Mesa, AZBuilt 1962 · S/N 17249934 N23353Weems Widener E · San Antonio, TXBuilt 1974 · S/N 17264085 N2335EMindy Limited LLC · Muscatine, IABuilt 1978 · S/N 17271240 N2335UDolphin Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9997 N2336UWilson Milledge L · Prosperity, SCBuilt 1962 · S/N 17249936 N2336VW Tech Consulting Inc · Wilmington, DEFirst renewal noticeBuilt 2007 · S/N 172S10536 N2338VLima 001 LLC · Muscatine, IABuilt 2007 · S/N 172S10538 N2338WChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280698 N233AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2004 · S/N 172S9770 N233CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12336 N233EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13096 N233FFArq Aviation LLC · Wilmington, NCBuilt 2026 · S/N 172S13573 N233TCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 17257920 N2342EWolf John J · Mooresville, NCBuilt 1978 · S/N 17271245 N2345Riotte Frederick · Suffield, CTS/N 17266419 N2345URenkel Albert D · Las Vegas, NVBuilt 1962 · S/N 17249945 N2345ZRegistered aircraftBuilt 1977 · S/N 17270190 N2348UWojnar Ronald T · East Troy, WIBuilt 1962 · S/N 17249948 N23497Full Throttle Aviation LLC · Clayton, DEBuilt 2007 · S/N 172S10512 N234EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13098 N234FFAviato I LLC · Palo Alto, CABuilt 2026 · S/N 172S13574 N234GMCunningham Hal A · Standard, CABuilt 1976 · S/N 17266438 N234JGBartlett William F · Jackson, WYBuilt 1975 · S/N 17265225 N234PCCaldwell Larry R · Florence, KYBuilt 1985 · S/N 17276321 N234RMWilliams Walt A · Mena, ARBuilt 1964 · S/N 17252230 N234SHAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11609 N234TSGolod David A · Ossining, NYBuilt 1977 · S/N 17268634 N234VRSnyder Jack W · Cheney, KSBuilt 1976 · S/N 17267422 N234WAWiseman Aviation Inc · Flagstaff, AZBuilt 1975 · S/N 17265581 N234ZGAtlas Aviation LLC · Buckhannon, WVBuilt 1978 · S/N 17270998 N2350EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271246 N2353USelman Charles D · Pflugerville, TXS/N 17249953 N2354EGaruda Flight Training LLC · Miami, FLBuilt 1979 · S/N 172-72777 N23556Aerospring Leasing LLC · Wasilla, AKBuilt 2005 · S/N 172S10095 N23557Flying Dutchman LLC · Wilmington, DEBuilt 2005 · S/N 172S10096

Back to AD 90-06-03 R1