Skip to content

Registered aircraft · 40,471

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N8856LRuales Edison R · Miami, FLFirst renewal noticeBuilt 1974 · S/N AA5-0656 N8856NGrant Shane J · Cape Coral, FLBuilt 1969 · S/N 28-25711 N8857Aviation Management Systems LLC · Fallbrook, CABuilt 1973 · S/N 254-73 N8857DHollan William E Jr · Winston Salem, NCBuilt 1958 · S/N 22-6028 N8857JNguyen Tu K · Costa Mesa, CABuilt 1965 · S/N 28-2822 N8857MDunn Brady · Gilmer, TXS/N M-597 N8857NWolf Terry T · Lake Katrine, NYBuilt 1969 · S/N 28-25712 N8858JBirdie N88 LLC · Conifer, COBuilt 1965 · S/N 28-2928 N8859DBbc Group LLC · Sanford, NCBuilt 1958 · S/N 22-6030 N8859NThrash Enterprises LLC · Clarksville, TNBuilt 1969 · S/N 28-5340 N885SABlevins Edgar R · Zachary, LABuilt 2001 · S/N 0014 N8860DCooley Tony A · Dallas, ORBuilt 1958 · S/N 22-6032 N8860JBjg LLC · Langdon, NHBuilt 1965 · S/N 28-2826 N8861FMurtaza Syed S · Minneapolis, MNBuilt 1976 · S/N 28-7715292 N8861NMcdonald Timothy A · Rush City, MNBuilt 1969 · S/N 28-25410 N8862FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 28-7715293 N8862LTisdale Matthew · Alameda, CABuilt 1974 · S/N AA1B-0362 N8862NHatley Wayne S · Hermitage, TNBuilt 1969 · S/N 28-25717 N8862YState Of Montana · Helena, MTBuilt 1973 · S/N 18-7409026 N8863DSanders Darrel T · Camp Douglas, WIBuilt 1958 · S/N 22-6037 N8864DMarsteller Paul A · Tallulah Falls, GABuilt 1958 · S/N 22-6038 N8866NYu Hermon Lemuel C · Mays Landing, NJBuilt 1969 · S/N 28-26251 N8866YCarson Ryan P · Albuquerque, NMBuilt 1971 · S/N 28-7125339 N8867NMulloy Dennis · Indian Mound, TNBuilt 1969 · S/N 28-25729 N8867PAnderson Keith C · Puyallup, WABuilt 1970 · S/N 18-8867 N8868JGannon Robert M · Hamburg, NYBuilt 1968 · S/N 28-24354 N8869JRoot Roger T · Moscow, IDBuilt 1965 · S/N 28-2841 N8869NCarland Ralph B · Altoona, PABuilt 1969 · S/N 28-25731 N886ECUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816262 N886PBarrons Aviation Services LLC · Henderson, NVBuilt 1962 · S/N 2328 N886RASmith Daryl N · Coventry, CTBuilt 1959 · S/N 22-6944 N886RVBazazan Mehrdad D · Fredericksburg, VABuilt 1994 · S/N 21707 N886SACumbass David Shane · Douglas, GABuilt 2000 · S/N 0004 N8870DHaumschild Edward E · Marana, AZBuilt 1958 · S/N 22-6044 N8870JAsel LLC · North Charleston, SCS/N 28-2842 N8870NRiley Dennis M · Surry, MEBuilt 1969 · S/N 28-25732 N8871DSmith James A · Lyle, WABuilt 1958 · S/N 22-6045 N8871JJohnson Richard E · Mulberry, FLBuilt 1965 · S/N 28-2843 N8871NCramer Michael L · Rockville Centre, NYBuilt 1969 · S/N 28-25733 N8872DJohnson Robert M · Ada, MNBuilt 1958 · S/N 22-6046 N8872GN8872g Holdings LLC · Nashville, TNBuilt 1966 · S/N 15062972 N8872JPriority Aviation LLC · Lewes, DES/N 28-2844 N8873DWroe Daniel C · Denton, MDBuilt 1958 · S/N 22-6047 N8874CPleasant Valley Aviation Inc · Bellefonte, PABuilt 1976 · S/N 28-7625135 N8874JMelland Curtis B · Hazen, NDBuilt 1965 · S/N 28-2847 N8874NFisher Tim A · Stockton, MDBuilt 1969 · S/N 28-25737 N8875DBishop Bill I · Cross Plains, TXBuilt 1958 · S/N 22-6049 N8875NMcclendon Charles Dowel · Lynchburg, VABuilt 1969 · S/N 28-25738 N8876JDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2848 N8876MLohman Curtis · Shelby, MIBuilt 1964 · S/N M-618

Back to AD 80-04-03 R2