Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N5874RHammel Tyler S · Dufur, ORBuilt 1965 · S/N 17253543 N5875RHepburn Joseph C · Towanda, KSBuilt 1965 · S/N 17253544 N5876AThomas Christopher D · Santa Monica, CABuilt 1956 · S/N 28476 N5876EFoster Garry R · Advance, NCBuilt 1959 · S/N 17376 N5876RJasmer Craig G · Puyallup, WABuilt 1965 · S/N 17253545 N5877AMangham Aviation LLC · Mullin, TXBuilt 1956 · S/N 28477 N5877GClegg Stephen A · Port Orange, FLBuilt 1969 · S/N 15071377 N5877RRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1965 · S/N 17253546 N58789Murphy Kristopher R · Mount Horeb, WIS/N 1A N5879EDrennan Monte Dean · Caddo, OKBuilt 1959 · S/N 17379 N5881RRengel Ronald J · Mundelein, ILBuilt 1965 · S/N 17253550 N5882RGrow Aviation LLC · Aurora, NEBuilt 1965 · S/N 17253551 N5883EHowser Kevin E · Fort Ashby, WVBuilt 1959 · S/N 17383 N5883GDerry Delmar D · New Market, IABuilt 1969 · S/N 15071383 N5884ADe Witt Duane A · Colleyville, TXBuilt 1956 · S/N 28484 N5885EZeller Bruce C · Shelton, WAS/N 17385 N5886QPasterski Sabrina Gonzalez · Chicago, ILBuilt 2006 · S/N 1 N5886RZimmer James D · Mason City, NEBuilt 1965 · S/N 17253555 N5888DBruce Gregory L · Yelm, WABuilt 1956 · S/N 18-5312 N5888RTepper Steve D · Stayton, ORBuilt 1965 · S/N 17253557 N588ADurham Devin L · Springfield, MOBuilt 1966 · S/N HS-1 N588BMiller Russell E · Houston, TXS/N HS2000 N588LCProdonor LLC · Phoenix, AZBuilt 1965 · S/N 17253895 N5890AMartin Jason L · Fort Worth, TXBuilt 1956 · S/N 28490 N5890GPommer Timothy J · Kittanning, PABuilt 1969 · S/N 15071390 N5890RYell Christopher R · Williamsburg, KYBuilt 1965 · S/N 17253559 N5891GWebb Christopher L · Burns, TNBuilt 1969 · S/N 15071391 N5893EWafer James R · Buellton, CABuilt 1959 · S/N 17393 N5894RMurray Kevin D · Moneta, VABuilt 1965 · S/N 17253563 N5895ADuncan Russell A · Glen Burnie, MDBuilt 1956 · S/N 28495 N5895DOgg Kevin · Sonora, CABuilt 1956 · S/N 18-5404 N5895RBernhard Sterling · Harper, TXBuilt 1965 · S/N 17253564 N5896AFox Black Enterprises Inc · Kilmarnock, VABuilt 1956 · S/N 28496 N5896EKyle James H · Snohomish, WABuilt 1959 · S/N 17396 N5896GYtsera Air Fred LLC · Lyndonville, VTBuilt 1969 · S/N 15071396 N5896RRegistration Pending · Florence, MSRegistration pendingBuilt 1965 · S/N 17253565 N5898GIsaza Alvaro · Westminster, MDBuilt 1969 · S/N 15071398 N5899RParrish Aviation Flight Academy LLC · Dallas, TXS/N 17253568 N589BBBullard Daniel C · Dallas, TXS/N AL-1085 N589JWTownley-Wren Adam T · Orwell, VTS/N 370 N58DMMoehn Dennis H · Oshkosh, WIBuilt 2014 · S/N 75-8449 N58FBurch Michael H · Bowling Green, FLS/N 11593 N58FAAlman Michael C · Fruitport, MIBuilt 1958 · S/N 55255 N58KBKientz William H Trustee · Chesterfield, MOBuilt 1946 · S/N 2216 N58VHDe Matteo Kenneth R · Grover Beach, CABuilt 1964 · S/N 3 N58WKern Aviation LLC · Shafter, CABuilt 1960 · S/N 15059094 N5900AOlsen Porteous E · Houston, MNBuilt 1956 · S/N 28500 N5900EGreene Charles A · Easley, SCBuilt 1959 · S/N 17400 N5900RAidan Hammond · Ione, CABuilt 1965 · S/N 17253569 N5901ACoulson Michael D · Zanesville, OHBuilt 1956 · S/N 28501

Back to AD 94-05-05 R1