Skip to content

Registered aircraft · 40,395

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.

N4076HSummerskyz Inc · Saint Joseph, ILBuilt 1991 · S/N 1799 N4076XAllen Kent E · Jacksonville, ILBuilt 1971 · S/N 5176 N40776Third Coast Aircraft LLC · Mobile, ALBuilt 1973 · S/N 28-7425163 N4077ZN4077z LLC · Wasilla, AKBuilt 1964 · S/N 18-8091 N40787Henrich Perrin · Northridge, CABuilt 1973 · S/N 28-7425164 N4078PHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1991 · S/N 1806 N4078XEspey Brendan L · Sandy Springs, GABuilt 1970 · S/N 5178 N40798Hovnanyan Ari · Woodland Hills, CABuilt 1973 · S/N 28-7415087 N4079XRichardson Scott · Grapevine, TXBuilt 1970 · S/N 5179 N4079ZNewton James K · Charles Town, WVBuilt 1963 · S/N 18-8093 N407FTSlipstream Inc · Cincinnati, OHBuilt 1982 · S/N 28-8216216 N407MNMaldonado Leopoldo · Paramount, CABuilt 1983 · S/N 407 N407SGriffing Flying Service Inc · Port Clinton, OHBuilt 1979 · S/N 28-7990545 N407WBBad Dog Aviation LLC · Wasilla, AKBuilt 1963 · S/N 18-8085 N40806Sky Dream Flight School LLC · Dallas, GABuilt 1973 · S/N 28-7425169 N4080ZVan Dyke Brian S · Rio Oso, CABuilt 1964 · S/N 18-8094 N40810Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 28-7415088 N40812Dae Aviation Enterprises Corp · Gilford, NHBuilt 1973 · S/N 28-7405068 N4081EOrlando Aircraft Sales LLC · Orlando, FLBuilt 1991 · S/N 1916 N40823Ashley Aviatrix LLC · Atlanta, GABuilt 1973 · S/N 28-7425173 N40829Shively Ray F · Turtlepoint, PABuilt 1973 · S/N 28-7415090 N4082JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1794 N4082XLeach Joey D · Flat Rock, INBuilt 1971 · S/N 5182 N40830Spirit Of Rocky Mount LLC · Nashville, NCFirst renewal noticeBuilt 1973 · S/N 28-7415091 N40836Hawkins Joshua L · Colbert, GABuilt 1973 · S/N 28-7425176 N40838Andrews Mark F · Jacksonville, FLBuilt 1973 · S/N 28-7415093 N4083EHulsey Steven M · Chugiak, AKBuilt 1977 · S/N 18-7809056 N4083XKnutson Wayne R · Thompson, NDBuilt 1971 · S/N 5183 N4083ZRaymond Raphael T · Helix, ORBuilt 1964 · S/N 18-8098 N40842Avz Aviation Inc · Knoxville, TNBuilt 1973 · S/N 28-7415094 N40845Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1973 · S/N 28-7405070 N4084EIngham Ben B · Sonora, TXS/N 18-7809058 N4084TEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1863 N4084ZHull Keath C · Wasilla, AKFirst renewal noticeBuilt 1964 · S/N 18-8099 N40850Mitchell Timothy · Enterprise, ALBuilt 1973 · S/N 28-7425178 N40856Griggs Gerald A · Blairsville, GABuilt 1973 · S/N 28-7425180 N40857Muller-Levan Christina J · Kempton, PABuilt 1973 · S/N 28-7415099 N40858Dicey Aviation LLC · Somerset, KYBuilt 1973 · S/N 28-7415102 N4085EGrass Roots Flying Inc Trustee · Wilmington, DEBuilt 1978 · S/N 18-7809059 N4085PTango Bravo Aviation LLC · Taylorsville, MSBuilt 1959 · S/N 23-1563 N4085WIrvin Gary Z · Parrish, FLFirst renewal noticeBuilt 2001 · S/N 25190 N40862Ratliff William Thomas III · Knoxville, TNBuilt 1973 · S/N 28-7405072 N40872Ole South Aviators LLC · Athens, GAS/N 31-8152134 N40874Jones Sherman Farrell · Buena Park, CABuilt 1973 · S/N 28-7425184 N40876Gray John W · Rohnert Park, CABuilt 1973 · S/N 28-7415100 N4087PPankratz Laura M · Stroudsburg, PABuilt 1959 · S/N 23-1565 N4087ZNcsb LLC · Anchorage, AKBuilt 1964 · S/N 18-8102 N40881Hsu Feng · Albuquerque, NMS/N 28-7425185 N40882Flight Factory LLC · Danville, CABuilt 1973 · S/N 28-7415105 N4088FCole Warren G · Watkinsville, GABuilt 1976 · S/N 28-7725002

Back to AD 79-10-03 R2