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.

N586CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12129 N586SRice James L · Mckinney, TXBuilt 1981 · S/N 17274646 N5870AGlenn Chester L · Hugo, OKBuilt 1956 · S/N 28470 N5872RMckee Joseph R · Godfrey, ILBuilt 1965 · S/N 17253541 N5873AWilemon Stephen L · Tulsa, OKBuilt 1956 · S/N 28473 N5873R3 Points LLC · Comstock Park, MIBuilt 1965 · S/N 17253542 N5874AShaha Zachary D · Menomonie, WIBuilt 1956 · S/N 28474 N5874RHammel Tyler S · Dufur, ORBuilt 1965 · S/N 17253543 N5875ARoberts Dallon W · Kamiah, IDS/N 28475 N5875RHepburn Joseph C · Towanda, KSBuilt 1965 · S/N 17253544 N5876AThomas Christopher D · Santa Monica, CABuilt 1956 · S/N 28476 N5876RJasmer Craig G · Puyallup, WABuilt 1965 · S/N 17253545 N5877AMangham Aviation LLC · Mullin, TXBuilt 1956 · S/N 28477 N5877RRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1965 · S/N 17253546 N5878ESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 17271949 N587ERTextron Aviation Inc · Wichita, KSS/N 172S13614 N587SPPinnacle Aviation Services Inc · Encinitas, CABuilt 2000 · S/N 172S8518 N5880ENashville Skyscrapers LLC · Old Hickory, TNBuilt 1978 · S/N 17271950 N5881RRengel Ronald J · Mundelein, ILBuilt 1965 · S/N 17253550 N5882RGrow Aviation LLC · Aurora, NEBuilt 1965 · S/N 17253551 N5884ADe Witt Duane A · Colleyville, TXBuilt 1956 · S/N 28484 N5886RZimmer James D · Mason City, NEBuilt 1965 · S/N 17253555 N5888ADahlberg James C · Ogilvie, MNS/N 28488 N5888RTepper Steve D · Stayton, ORBuilt 1965 · S/N 17253557 N5889RPatkotak Crawford A · Barrow, AKS/N 17253558 N588ERTextron Aviation Inc · Wichita, KSS/N 172S13617 N588LCProdonor LLC · Phoenix, AZBuilt 1965 · S/N 17253895 N5890AMartin Jason L · Fort Worth, TXBuilt 1956 · S/N 28490 N5890RYell Christopher R · Williamsburg, KYBuilt 1965 · S/N 17253559 N5891RTun Bay Inc · Wasilla, AKBuilt 1966 · S/N 17253560 N5894RMurray Kevin D · Moneta, VABuilt 1965 · S/N 17253563 N5895ADuncan Russell A · Glen Burnie, MDBuilt 1956 · S/N 28495 N5895RBernhard Sterling · Harper, TXBuilt 1965 · S/N 17253564 N5896AFox Black Enterprises Inc · Kilmarnock, VABuilt 1956 · S/N 28496 N5896RRegistration Pending · Florence, MSRegistration pendingBuilt 1965 · S/N 17253565 N5899RParrish Aviation Flight Academy LLC · Dallas, TXS/N 17253568 N589SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2000 · S/N 172S8519 N58DSBalliet Edgar J III · Northampton, PABuilt 1979 · S/N 17272305 N58FFWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 172S12928 N58TYJohnson Jake M · Texarkana, TXBuilt 1977 · S/N 17270111 N5900AOlsen Porteous E · Houston, MNBuilt 1956 · S/N 28500 N5900RAidan Hammond · Ione, CABuilt 1965 · S/N 17253569 N5901ACoulson Michael D · Zanesville, OHBuilt 1956 · S/N 28501 N5902ASmith Kenneth W · Bedford, INBuilt 1956 · S/N 28502 N5902RWojcik Dorene L · Cortland, OHS/N 17253571 N5903AHunt Kenneth · Humble, TXBuilt 1956 · S/N 28503 N5905RSmart Harold J · Locust Grove, GABuilt 1965 · S/N 17253574 N5906AGnb Aviation LLC · Lake City, TNBuilt 1956 · S/N 28506 N5906ROlson Bradley P · Pendleton, ORBuilt 1965 · S/N 17253575 N5907ERiver City Flying Club Inc · Valley Center, KSBuilt 1978 · S/N 17271957

Back to AD 90-06-03 R1