Skip to content

Registered aircraft · 40,394

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:79-10-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') 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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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:79-10-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
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.

N8408BCharlton Gary R II · Loudonville, NYBuilt 1981 · S/N 28-8116258 N8408CDallas Secure Storage LLC · Dallas, ORBuilt 1976 · S/N 28-7625113 N8408DAeromarine Consulting Inc · Brandon, FLS/N 22-5661 N8408ECandace A Larned Enterprises Inc · Long Beach, CABuilt 1981 · S/N 28-8116259 N8408LMacair Aviation LLC · Xenia, OHBuilt 1981 · S/N 28-8116261 N8408RWilliams Christopher A · Kent, WAS/N 28-22285 N84092Brown Stephen J · Chandler, AZBuilt 1969 · S/N 17258328 N84093Hruska Coyle J · Lime Springs, IABuilt 1969 · S/N 17258329 N84097Argoudelis Michael · Kalamazoo, MIS/N 17258331 N8409DWinters David W · Gustine, TXBuilt 1957 · S/N 22-5662 N8409LRegistered aircraftBuilt 1968 · S/N 17256609 N8409PStevenson Gregory J · Sutter Creek, CABuilt 1964 · S/N 24-3665 N8409RRatliff Christopher · Manteno, ILBuilt 1966 · S/N 28-22286 N84104Morris Daniel B · Ankeny, IABuilt 1969 · S/N 17258334 N84108Bramblett John S · Russellville, ARBuilt 1969 · S/N 17258337 N84109Bielak Donald · Louisburg, KSBuilt 1981 · S/N 28-8290034 N8410CLevel Up Aviation LLC · Newton, ALBuilt 1976 · S/N 28-7615105 N8410ETito Hector · Fayetteville, GABuilt 1979 · S/N 17272196 N8410LVictory Lane Aviation LLC · Concord, NCBuilt 1968 · S/N 17256610 N8410SNorth Shelby Aviation LLC · Wilmington, DEBuilt 1981 · S/N 28-8116263 N8410WRenegade6 Aviation LLC · Woodbridge, VABuilt 1965 · S/N 28-2629 N84114Miami Seaplane Tours Inc · Miami, FLBuilt 1969 · S/N 17258339 N84117Mendez Arturo · Addison, ILBuilt 1969 · S/N 17258340 N8411BGrohs Dihl J · Wessington Springs, SDBuilt 1981 · S/N 28-8190275 N8411CRtb Aviation LLC · Jurupa Valley, CABuilt 1976 · S/N 28-7690136 N8411DElliott Frank F · Mojave, CABuilt 1957 · S/N 22-5664 N8411REleven Romeo LLC · Golden, COBuilt 1966 · S/N 28-22288 N8411WHiggins Timothy Owen · Axtell, TXS/N 28-2635 N84122Millican Marc J · Anchorage, AKBuilt 1969 · S/N 17258342 N84125Koenig Aircraft Restoration Inc · Loranger, LABuilt 1969 · S/N 17258343 N84129Petschow Kenneth W · Upland, CABuilt 1969 · S/N 17258344 N8412CEiler Marc · Seattle, WAS/N 28-7690137 N8412LAddison Flying LLC · Addison, NYBuilt 1968 · S/N 17256612 N8412RChamberlain Richard T · Collinsville, ILBuilt 1966 · S/N 28-22289 N8412WSutton Timothy A · Glencoe, ALS/N 28-2636 N84130Gutierrez Sergio E · Pharr, TXBuilt 1969 · S/N 17258345 N84133Registration Pending · Bowman, NDRegistration pendingS/N 17258347 N8413LRussell Adam G · Easton, MES/N 17256613 N8413RZuniga Hector Javier · Mission, TXBuilt 1966 · S/N 28-22290 N8413WHollier Gregory J · Arnaudville, LABuilt 1965 · S/N 28-2637 N8413YReinbold Frederick K · Anchorage, AKBuilt 1969 · S/N 18-8858 N84140Kaiser Joe E · Anchorage, AKBuilt 1969 · S/N 17258351 N84141Registration Pending · Mansfield, OHRegistration pendingBuilt 1969 · S/N 17258352 N84143Jones Donald T · Barrigada, GUS/N 17258353 N84146Stone Air LLC · Carrollton, GABuilt 1969 · S/N 17258354 N84147Cox James O II · Shady Shores, TXBuilt 1969 · S/N 17258355 N8414FPenley Robert G · Corinth, TXBuilt 1976 · S/N 28-7725111 N8414LMorris Christopher J · Manor, TXBuilt 1968 · S/N 17256614 N8414M8414m LLC · Nunica, MIBuilt 1981 · S/N 28-8190276 N8414NAirlake Aero Inc · Lakeville, MNBuilt 1981 · S/N 28-8190278

Back to AD 79-10-03 R2