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.

N8229UBurmeister James · Roseville, CABuilt 1964 · S/N 17252129 N8229XReynolds Lawrence C Jr · Anderson, INBuilt 1961 · S/N 17248729 N822EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12827 N822KTJet Air Inc · Iowa City, IABuilt 1999 · S/N 17280545 N822MLMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265684 N822MNLucky B Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9260 N8230BGrieff Jorden A · Rome, GAS/N 36030 N8230LBridle Bit Ranch Co · Gillette, WYBuilt 1967 · S/N 17256430 N8231BRegistration Pending · Wilmington, DERegistration pendingBuilt 1957 · S/N 36031 N8231XGhaderi Homayoun · Oakland, CABuilt 1961 · S/N 17248731 N8233LKensinger Steve · North Pekin, ILS/N 17256433 N8234BCook Christopher L · Mt Juliet, TNBuilt 1957 · S/N 36034 N8234URegistered aircraftBuilt 1964 · S/N 17252134 N8235ULind Gerald Wayne · Oakley, IDS/N 17252135 N8236GVinton Timothy R · Whitman, NEBuilt 1979 · S/N 17273618 N8236LCiroli Kenneth E · Indiana, PAFirst renewal noticeBuilt 1967 · S/N 17256436 N8237UNo Money For Plane LLC · Grand Rapids, MIBuilt 1964 · S/N 17252137 N8238UPowers Robert · Iowa City, IABuilt 1964 · S/N 17252138 N8239LSkys Edge Aviation LLC · Midland, TXBuilt 1967 · S/N 17256439 N8239XHess Dan A · Hastings, NEBuilt 1962 · S/N 17248739 N823CKSpirit Aviation Management Services Inc · Thomson, GABuilt 2022 · S/N 172S12891 N823DAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12566 N823EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13040 N823KSKansas State University Salina · Salina, KSBuilt 1999 · S/N 17280547 N823MCN823mc LLC · Kennesaw, GABuilt 2008 · S/N 172S10713 N823PWSpradley Jeff D · White Springs, FLBuilt 1964 · S/N 17250896 N8240LCactus To Clouds Aviation LLC · Indio, CABuilt 1967 · S/N 17256440 N8241BBalint Jozef · Fort Worth, TXBuilt 1956 · S/N 36041 N8241URegistration Pending · Casa Grande, AZRegistration pendingBuilt 1964 · S/N 17252141 N8241XRotormate LLC · Royse City, TXBuilt 1961 · S/N 17248741 N8242BLibby Robert E · Windham, MEBuilt 1957 · S/N 36042 N8242XSadique Said-Hesamadine · Fairfax, VAS/N 17248742 N8243EMacon Air LLC · Franklin, NCBuilt 1979 · S/N 17272155 N8243XDemetreu Thomas J · Almond, NYBuilt 1961 · S/N 17248743 N8246BBoyer Christopher · Bozeman, MTBuilt 1957 · S/N 36046 N8246LPatak Eva L · Ennis, TXBuilt 1967 · S/N 17256446 N8247BDoughty Robert W · Casa Grande, AZBuilt 1957 · S/N 36047 N8247LKnepp Terry · Montgomery, INBuilt 1967 · S/N 17256447 N8247UComeau Paul D · Walden, NYBuilt 1964 · S/N 17252147 N8248LBattleshaw Raymond · Weidman, MIBuilt 1967 · S/N 17256448 N8248URobison Wm Lee · Smithville, MOBuilt 1964 · S/N 17252148 N8249UDracka Charles L · Port Clinton, OHS/N 17252149 N8249XDish Technologies LLC · Elm City, NCBuilt 1961 · S/N 17248749 N824EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12828 N824KSPlanelease LLC · Venice, CABuilt 1999 · S/N 17280564 N824MCMidwest Aviation Services Inc · West Paducah, KYBuilt 2008 · S/N 172S10714 N824RNCh Wings LLC · Arvada, COBuilt 2025 · S/N 172S13288 N8250BMortenson Daniel R Trustee · Newhall, CABuilt 1957 · S/N 36050 N8250LStieler David C · Marlette, MIBuilt 1967 · S/N 17256450 N8250UCalderon Daniel · Orlando, FLS/N 17252150

Back to AD 90-06-03 R1