Registered aircraft · 108,433

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N2480SAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 21061299 N2480VLyons Emily A · Homewood, ALBuilt 1985 · S/N 28-8590075 N2481CPippert Jim · Dysart, IABuilt 1954 · S/N 30781 N2481GEaster Brett D · Enumclaw, WABuilt 1959 · S/N 51781 N2481REngh Robert G · Laurel, MTBuilt 1964 · S/N 18255581 N2481TWidell Randall Ross · Wilsonville, ORBuilt 1971 · S/N 28-7205058 N2481UWilliams Jeremy · Searsport, MES/N U20602380 N2482CMiller Richard W · Bellingham, WABuilt 1954 · S/N 30782 N2482QFox John E · Boonville, CABuilt 1966 · S/N 18257682 N2482TTouchpoint International Development Group Inc · Fayetteville, NCS/N NAV-4-2482 N2483FMiller Clinton J · Traverse City, MIBuilt 1966 · S/N 18051685 N2483GLenox Mark W · Idaho Falls, IDS/N 51783 N2483JWestern Pilot Service Inc · Phoenix, AZBuilt 1979 · S/N 18803467T N2483MLanners Thomas P · Chickaloon, AKBuilt 1947 · S/N 12-1684 N2483QMarch Kenrick D · Kingwood, TXBuilt 1966 · S/N 18257683 N2483RSkydive Twin Cities LLC · Baldwin, WIS/N 18255583 N2484CLejeune Aerial Applications LLC · Basile, LABuilt 1954 · S/N 30784 N2484FJones William Ransom · Anchorage, AKBuilt 1966 · S/N 18051686 N2484TAmetza LLC · El Centro, CABuilt 1962 · S/N NAV-4-2484 N2485ALees Jerry D · Fairbanks, AKBuilt 1952 · S/N 18-1954 N2485GBack Country Guys LLC · Prescott, AZBuilt 1959 · S/N 51785 N2485QPayne Scott M · Twin Bridges, MTBuilt 1966 · S/N 18257685 N2485RGriffith Kyle R · Talihina, OKBuilt 1969 · S/N 28-5633 N2485TRothrock Virgil N · Streator, ILBuilt 1962 · S/N NAV-4-2485 N2485XLostetter Evan · Bakersfield, CABuilt 1985 · S/N 28-8516069 N2486CArmstrong Patrick Trustee · Bishop, CABuilt 1954 · S/N 30786 N2486GDenton Bob · Nampa, IDBuilt 1959 · S/N 51786 N2486PWoods Jerry Lee II · Murchison, TXBuilt 1955 · S/N 22-2860 N2486RCain James W · Big Rapids, MIBuilt 1964 · S/N 18255586 N2486XGreat Escape Aviation LLC · Marquette, MIBuilt 1965 · S/N 18256386 N2487GRegistration Pending · Aledo, TXRegistration pendingBuilt 1959 · S/N 51787 N2487HEllis Wendell K · Chugiak, AKBuilt 1979 · S/N 18-7909195 N2487RCummings Sean · Lombard, ILBuilt 1964 · S/N 18255587 N2487SMoody Bible Institute Of Chicago · Spokane Valley, WAS/N R18201344 N2488APetrik Kale O · Sidney, MTBuilt 1952 · S/N 18-1969 N2488GRumley Orville C · Minco, OKBuilt 1959 · S/N 51788 N2488MMeads Rodney L · Camden, NCBuilt 1977 · S/N 28-7816289 N2488PPs Engineering Inc · Lenoir City, TNBuilt 1999 · S/N 2843282 N2488RCorprew Gerard A · Callao, VABuilt 1964 · S/N 18255588 N2488TForsberg Edwin Eugene · Elk Grove, CABuilt 1962 · S/N NAV-4-2488 N2488XCentral Oil Co LLC · Mcminnville, TNBuilt 1965 · S/N 18256388 N2489ALong Patrick B · Buffalo, WYS/N 18-1957 N2489CRegistered aircraftBuilt 1954 · S/N 30789 N2489GRogers Gregory J · Plesant Hill, MOBuilt 1959 · S/N 51789 N2489TMoore Robert C · Edison, CABuilt 1962 · S/N NAV-4-2489 N2489XVanderweel Martha · Wolcott, NYBuilt 1965 · S/N 18256389 N248AMDesfosse Donald J Trustee · Andover, MABuilt 1996 · S/N 3246054 N248BFotheringham Jack · Palmer, AKS/N 28-7505135 N248BFBohmer Alexander J · Moorhead, MNBuilt 2008 · S/N 5337 N248CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881003

Back to AD 2007-04-19 R1