Skip to content

Registered aircraft · 20,687

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.

N865PAPlatinum Angel LLC · Melbourne, FLBuilt 2006 · S/N 172S10176 N8660BNaramore Tyler R · Salem, MOBuilt 1957 · S/N 36360 N8660USage Point Ventures LLC · New Harmony, UTS/N 17252562 N8661BBottorf Benjamin R · Springfield, ILS/N 36361 N8661UBaird Adam D · Salisbury, NCBuilt 1965 · S/N 17252564 N8662BPark Arthur N · College Park, GABuilt 1957 · S/N 36362 N8663USocks Flyers LLC · Southgate, KYS/N 17252566 N8664BBoyer Cal A · Cleona, PABuilt 1957 · S/N 36364 N8665URathbun Kendrick C · Ocala, FLBuilt 1965 · S/N 17252568 N8666BHultquist Casey D · Anchorage, AKS/N 36366 N8666USchultz Mark S · Mokena, ILBuilt 1965 · S/N 17252569 N8667BHaingray Donald F · Houghton, NYBuilt 1957 · S/N 36367 N8667UHillier Ian P · Hummelstown, PABuilt 1965 · S/N 17252570 N8668BFriesen Conrad · Lott, TXBuilt 1957 · S/N 36368 N8668UGragg Michael W · Newland, NCS/N 17252571 N866CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12634 N8670USkyhawk Aviation LLC · Oskaloosa, IAS/N 17252573 N8671BBoas Edward E Jr · Chesapeake City, MDBuilt 1957 · S/N 36371 N8672BVolker Bradley B · Rice Lake, WIBuilt 1957 · S/N 36372 N8672UEcho Tango LLC · Milledgeville, GABuilt 1965 · S/N 17252575 N8673UCarpenter Alan B · Wasilla, AKBuilt 1965 · S/N 17252576 N8674UAngle Kevin D · Rocky Mount, VAS/N 17252577 N8675BMountain Express LLC · Haines City, FLBuilt 1957 · S/N 36375 N8677UHunter Richard Louis · Wilton, CABuilt 1965 · S/N 17252580 N8678URoane Aaron J · Ogden, UTBuilt 1965 · S/N 17252581 N8679ULake Aera Technical College · Watertown, SDBuilt 1965 · S/N 17252582 N867AAWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264498 N867CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11589 N867EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12675 N867LAHillsboro Aero Academy LLC · Hillsboro, ORS/N 172S8941 N8680BGabelli Alfred R · Grand Junction, COBuilt 1957 · S/N 36380 N8680URoberts Robert V · Sebastian, FLBuilt 1965 · S/N 17252583 N8681UFly Around Alaska LLC · Palmer, AKS/N 17252584 N8682UAircraft N8682u Inc · Half Moon Bay, CABuilt 1965 · S/N 17252585 N8683UConrad Richard M · Chinook, MTBuilt 1965 · S/N 17252586 N8684UOlsovsky Jesse C · Bonita Springs, FLBuilt 1965 · S/N 17252587 N8686BMcknight Thomas N · Fredericksburg, TXBuilt 1957 · S/N 36386 N8687BSelf Aviation LLC · Hayden, IDBuilt 1957 · S/N 36387 N8688BRegistered aircraftBuilt 1957 · S/N 36388 N8688USabol Andrew R · Waterville, NYBuilt 1965 · S/N 17252592 N8689BTeynor Jason J · Ontario, WIBuilt 1957 · S/N 36389 N868SAS O W Aviation LLC · Crystal River, FLS/N 17266439 N868SPWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 172S8128 N868TBSo Cal Leasing LLC · El Cajon, CABuilt 2003 · S/N 172S9311 N8691BHeller Teena · Granbury, TXBuilt 1957 · S/N 36391 N8692BCogan Walter J Jr · Shelter Island, NYBuilt 1957 · S/N 36392 N8693UCone Randall D · Salida, COBuilt 1965 · S/N 17252597 N8694BMiller Jason M · Eaton, OHBuilt 1957 · S/N 36394 N8697BHillis Gary D · Brookland, ARBuilt 1957 · S/N 36397 N869CPExecutive Flight Institute LLC · Murrieta, CABuilt 1999 · S/N 17280641

Back to AD 90-06-03 R1