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.

N2337UOne Niner Right LLC · Berkeley, CABuilt 1979 · S/N 28-7911300 N23383Performance Auto Body Inc · Knightdale, NCBuilt 1998 · S/N 18280406 N2338FDonnell James C · Crowville, LABuilt 1964 · S/N 21058538 N2338GIberlin Ranch · Gillette, WYBuilt 1958 · S/N 51638 N2338QWinkels Jeffrey P · Candy, MNFirst renewal noticeBuilt 1963 · S/N M-403 N2338VLima 001 LLC · Muscatine, IABuilt 2007 · S/N 172S10538 N2338WChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280698 N2338YCm3 LLC · North Las Vegas, NVS/N 2152 N2339CSullivan Nathan · Croton, OHS/N 30639 N2339GWetzel William W · Carrizozo, NMBuilt 1958 · S/N 51639 N2339PMulvania Rodney A · Linn, MOBuilt 1955 · S/N 22-2750 N2339RStephens Grant A · Palmer, AKBuilt 1964 · S/N 18255439 N2339TK E F Enterprises Inc · Plymouth, MABuilt 1971 · S/N 28R-7135227 N2339VBradford Sarah Elisabeth · Norman, OKBuilt 1985 · S/N 28-8511015 N2339XPetet David G · Orofino, IDBuilt 1965 · S/N 18256239 N2339YGross Barbara J · Timber Lake, SDS/N 17700139 N233AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2004 · S/N 172S9770 N233AKRoettele Mark · Lake Havasu City, AZBuilt 1991 · S/N CE-1609 N233CNw Beech Boys LLC · Everson, WABuilt 1969 · S/N CJ-18 N233CBZions Credit Corp · Salt Lake City, UTBuilt 2020 · S/N 2881389 N233CJCrown H Helicopter LLC · Casscoe, ARBuilt 2023 · S/N 14655 N233CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12336 N233CRWilliams Charles H · Granbury, TXBuilt 2003 · S/N 001 N233DKitley David Matthew · Dolores, COBuilt 1961 · S/N D-6753 N233DCMc Aviation Holdings LLC · Miami, FLBuilt 1998 · S/N 18280289 N233DFFleckenstein David · Nacogdoches, TXBuilt 1987 · S/N CE1171 N233DPProp 2 Fox LLC · Hudson, OHBuilt 2003 · S/N 931-2003 N233DWWentzell David M · Anderson, SCBuilt 2005 · S/N 25361 N233EESchroeder Glenda P · Evansville, INBuilt 2001 · S/N 1 N233EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13096 N233ESSpain Aviation LLC · Lynchburg, VABuilt 1992 · S/N CE-1683 N233FFArq Aviation LLC · Wilmington, NCBuilt 2026 · S/N 172S13573 N233GKGoodwin Joseph N · Grass Valley, CABuilt 1968 · S/N D-8777 N233GSGreenville County Sheriffs Office · Greenville, SCBuilt 1972 · S/N 18261018 N233HYTen Mile Ranch Inc · Vale, ORBuilt 2003 · S/N 2233 N233JDSulphur Creek Helicopters LLC · Three Rivers, TXBuilt 2004 · S/N 10300 N233JHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1977 · S/N 414A0009 N233JRNorthstar Aerospray Inc · Clara City, MNBuilt 1976 · S/N CE-643 N233LHLetts Jackson W · Kansas City, KSS/N CE-550 N233LMWayne Four LLC · Sugar Land, TXBuilt 2023 · S/N 14684 N233LSSelznick Larry Trustee · Stevenson Ranch, CABuilt 2004 · S/N 0885 N233MMartin Dennis E · Oconto, WIBuilt 1999 · S/N M1 N233MAMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2005 · S/N 40.511 N233MEEight Ball Flying Club · Van Nuys, CABuilt 2000 · S/N 18280750 N233MGFly Safe LLC · Belle Isle, FLBuilt 1980 · S/N R18201541 N233RPlane Jane Aviation LLC · Sylvania, GABuilt 1975 · S/N D9811 N233SBC2c LLC · Hamilton, MTBuilt 2002 · S/N 0242 N233SCMattoso Ricardo Q · Spicewood, TXBuilt 1974 · S/N D-9599 N233SFSale Reported · Wakarusa, INSale reportedBuilt 1999 · S/N 402-99 N233SPBuchwald Greg W · Grapevine, TXBuilt 1961 · S/N 28-223

Back to AD 2007-04-19 R1