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.

N9120HKrieg Kristi · Tonasket, WAS/N 17265954 N9121HTwenty-One Flyers Inc · Norwalk, CTBuilt 1975 · S/N 17265955 N9123BStockton Clifford A · Anchorage, AKBuilt 1958 · S/N 36723 N9123HTwenty Three Juliet LLC · Tyler, TXBuilt 1976 · S/N 17265957 N9127BBassham Rick D · Bluff Dale, TXBuilt 1958 · S/N 36727 N9127HMoraine Flying Club Inc · Butler, PABuilt 1975 · S/N 17265959 N9129BBoughroum Youssef · Grovetown, GABuilt 1958 · S/N 36729 N912ATPilot Rise Aircraft Holdings LLC · Fort Worth, TXBuilt 1982 · S/N 17275927 N912AZN912az LLC · Miami, FLBuilt 2003 · S/N 172S9475 N912JRN912jr LLC · Dover, DEBuilt 1999 · S/N 172S8200 N912LBArizona Flyers Club Inc · Tucson, AZBuilt 2000 · S/N 172S8609 N912YAChewelah Flyers · Chewelah, WAS/N 17264195 N9131HStroemsuik Kristian · Strasburg, VAS/N 17265962 N9134BJohnson Andrea J · Redlands, CABuilt 1958 · S/N 36734 N9134HRegistration Pending · Kalispell, MTRegistration pendingS/N 17265964 N9137BMeyer David E · Olathe, KSBuilt 1958 · S/N 36737 N9137HPilots Flying School LLC · Englishtown, NJBuilt 1975 · S/N 17265966 N9138HMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265967 N9139BFikes Richard Glen III · Flint, TXS/N 36739 N913CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8333 N913MAKennedy Michael J · Gilbert, AZBuilt 1999 · S/N 17280777 N9140BBunney Jared · Spokane Valley, WAS/N 36740 N9141BBurnham Gary · Helper, UTBuilt 1958 · S/N 36741 N9144BMason Matthew L · Lincoln, ILBuilt 1958 · S/N 36744 N9147BReed Zane · Mountain Home, IDBuilt 1958 · S/N 36747 N9149BFoust Kal E · Lenox, MIBuilt 1958 · S/N 36749 N914AZN969az LLC · Miami, FLBuilt 1985 · S/N 17276379 N914JDAis Wings LLC · Grand Rapids, MIBuilt 1972 · S/N 17261296 N914RRMartinez Jeff L · Lewistown, MTS/N 17264508 N914SCHotel Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13438 N914SWSilver Express Co DBA · Miami, FLBuilt 1999 · S/N 172S8160 N914ZSkylens LLC · Hammond, LABuilt 1974 · S/N 17264444 N91507Eagle Aviation LLC · Spearfish, SDBuilt 1973 · S/N 17261499 N9150BHarral Blake · Prescott Valley, AZFirst renewal noticeBuilt 1958 · S/N 36750 N9150HN9150h LLC · Charleston, SCBuilt 1975 · S/N 17265975 N9151HFirst Flight Corp · San Diego, CABuilt 1975 · S/N 17265976 N9153BMires James · Newnan, GABuilt 1958 · S/N 36753 N9153HSambriski Michael Daniel III · Long Beach, NYBuilt 1975 · S/N 17265978 N91553Simpson Josiah J L Trustee · Shelburne, MABuilt 1973 · S/N 17261500 N9156BRegistration Pending · Cheyenne, WYRegistration pendingBuilt 1958 · S/N 36756 N9156HSolar Flying Club · Grimes, IABuilt 1975 · S/N 17265981 N9156NBurdick Kenneth M · Swansea, MABuilt 1956 · S/N 28648 N9157A9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12755 N9157BMighells Conrad E · Randolph, NYFirst renewal noticeBuilt 1958 · S/N 36757 N9158HParrish Aviation Flight Academy LLC · Southlake, TXBuilt 1975 · S/N 17265982 N91596West Michigan Flying Club Inc · Norton Shores, MIBuilt 1973 · S/N 17261505 N9159HHess Garrett · Fullerton, CAS/N 17265983 N915AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13546 N915CMVaayu Aviation LLC · Newark, CABuilt 1972 · S/N 17261229 N915CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8335

Back to AD 90-06-03 R1