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.

N712SPAmeriflyers Of Texas Inc · Addison, TXBuilt 2000 · S/N 172S8640 N712TTAb Cessna LLC · Wilmington, NCBuilt 1981 · S/N 17275235 N7130AJohnston David E · Fort Myers, FLBuilt 1956 · S/N 29230 N7131AOneill Mark B · Pinckney, MIBuilt 1956 · S/N 29231 N7131TReyes Jose Daniel Cruz · Wilmington, NCBuilt 1959 · S/N 46731 N7132QAero Quest LLC · Olive Branch, MSBuilt 1972 · S/N 17260432 N7133APeacock Richelle L · Arcadia, FLBuilt 1956 · S/N 29233 N7133QPage Aerial Service Inc · Rochelle, ILBuilt 1972 · S/N 17260433 N7133TQuam Gary L · Rio, WIBuilt 1959 · S/N 46733 N7135AMoss Colin · Sparta, NCBuilt 1956 · S/N 29235 N7135QHoman Larry E · Sigourney, IABuilt 1972 · S/N 17260435 N7136ACross Frank · Huntsville, MOBuilt 1956 · S/N 29236 N7136QPa Lawrence LLC · Anchorage, AKBuilt 1972 · S/N 17260436 N7136TSnouffer Robert E · Mountain Grove, MOBuilt 1959 · S/N 46736 N7137ACarrico Drew E · Redway, CABuilt 1956 · S/N 29237 N7137TLeavitt John E · Palmer, AKBuilt 1959 · S/N 46737 N7138THudson Thomas C · Bessemer, ALBuilt 1959 · S/N 46738 N7139ATimothy Scott Bloom · Chugiak, AKBuilt 1956 · S/N 29239 N7139GSkysg LLC · Eugene, ORBuilt 1969 · S/N 17258839 N7139QFernander David · Enterprise, ALBuilt 1972 · S/N 17260439 N713BJRiley James A · Richmond, KYBuilt 1959 · S/N 46696 N713CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12529 N713FSTfs Air LLC · Loveland, COBuilt 2008 · S/N 17281513 N713JKSbarounis Carl A · Torrance, CABuilt 1975 · S/N 17265460 N713LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2015 · S/N 172S11660 N713RBKay Timothy A · Kyle, TXBuilt 2000 · S/N 172S8547 N713SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13579 N713SJKoerner James L Trustee · Gilbert, AZBuilt 1977 · S/N 17269713 N713SZN713sz LLC · Jacksonville, FLBuilt 2023 · S/N 172S12957 N71409Piedmont Flight Inc · Winston Salem, NCBuilt 1976 · S/N 17267227 N7140JCohesive Aviation LLC · Gilford, NHBuilt 1980 · S/N 17273901 N7140QMagnuson Jessica M · Olathe, KSBuilt 1972 · S/N 17260440 N7141AFarruggia John A · West Winfield, NYBuilt 1956 · S/N 29241 N7141GDyke Paul A · Hartford, SDBuilt 1969 · S/N 17258841 N7141JHutt Aviation Inc · Minden, NVS/N 17273902 N7141QFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260441 N7141TRosser David S · Lynn, ALBuilt 1959 · S/N 46741 N7142QObymachow Richard M · Killingworth, CTS/N 17260442 N71430Princeton Raptors Flying Club · Princeton, MNS/N 17263380 N7143GAllen Nathanael W · Bemidji, MNBuilt 1969 · S/N 17258843 N71444Rushville Flying Club Inc · Rushville, ILBuilt 1975 · S/N 172-65662 N7144GJc Flight Inc · Wilmington, DEBuilt 1969 · S/N 17258844 N7145TZacharias Norman R · Hinckley, MNFirst renewal noticeBuilt 1959 · S/N 46745 N7146GHalladay Roy · Erie, COBuilt 1969 · S/N 17258846 N7146QPressley Aviation LLC · New London, NCBuilt 1972 · S/N 17260446 N7147AAir Cover Academy LLC · Frankford, MOBuilt 1956 · S/N 29247 N7147GAffordable Flying LLC · Cedar Park, TXBuilt 1969 · S/N 17258847 N7147TMoody George A II · Dyersburg, TNBuilt 1959 · S/N 46747 N7149ASteffanic Matthew R · Bastrop, TXS/N 29249 N7149QS&H Aviation LLC · Columbus, INS/N 17260449

Back to AD 90-06-03 R1