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.

N253RRRoland Ronald W Trustee · Mckinney, TXBuilt 1953 · S/N 30253 N253RVWard Jeffrey K · Kennesaw, GABuilt 2009 · S/N 40253 N253SWBatts David · Lyons, COBuilt 1965 · S/N 28-2328 N253TPLeblanc John David · Deland, FLFirst renewal noticeBuilt 1987 · S/N 253 N253TSAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13470 N253WCba Investments LLC · Kalispell, MTBuilt 2004 · S/N 0881 N253WMLambert Timothy Allen Jr · Burleson, TXBuilt 1964 · S/N 28-2026 N253WPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2000 · S/N 18280743 N254Russell Dale Christopher · Sierra Vista, AZBuilt 1978 · S/N AA5B0970 N2540FMcguires Flying Service LLC · Obion, TNBuilt 1965 · S/N 96 N2540PReed Michael D · Parsons, KSBuilt 1955 · S/N 22-2903 N2540QAmt Aero Inc · Massapequa, NYBuilt 1977 · S/N 28-7790404 N2540RFreeman Josh · Turtle Lake, NDBuilt 1967 · S/N 18258240 N2540THenningsen Air LLC · Atlantic, IABuilt 1970 · S/N NAV-4-2540 N2541GDuvall Paul M · Scottsburg, INS/N 51841 N2541SLanning Danny E · Alzada, MTBuilt 1979 · S/N 18-7909156 N2541XEco Flite Service Inc · Lake Elsinore, CABuilt 1964 · S/N P2060041 N2542RThordarson Gudsteinn T · La Porte, INBuilt 1967 · S/N 18258242 N2542WYoder Enos D · Goshen, INBuilt 1985 · S/N 32R-8613001 N2542ZGreenway Jonathan J · Frederick, MDBuilt 1977 · S/N 344-77 N2543RSaddlery Air Inc · Des Moines, IABuilt 1967 · S/N 18258243 N2543URegistered aircraftBuilt 1979 · S/N 28-8090055 N2543ZSchindler Jason D · Oneill, NES/N 345-77 N2544GEnsman Enterprises LLC · Chino Valley, AZBuilt 1959 · S/N 51844 N2544PCoonfield Russell Adam · Fayetteville, ARBuilt 1955 · S/N 22-2907 N2544RBill Church Real Estate LLC · Midland, MIBuilt 1967 · S/N 18258244 N2544SSunrise Adventures LLC · Stillwater, MNBuilt 1979 · S/N 18-7909155 N2545CDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496324 N2545GSpokane Turbine Skydiving LLC · Medical Lake, WABuilt 1959 · S/N 51845 N2545PMatter Steven S · Joliet, ILFirst renewal noticeBuilt 1955 · S/N 22-2908 N2545RYad Aviation LLC · Cherry Hill, NJBuilt 1967 · S/N 18258245 N2545UMcmahon Patrick S · San Antonio, TXBuilt 1979 · S/N 28-8016032 N2545WRegistration Pending · Vienna, OHRegistration pendingBuilt 1974 · S/N MC-242 N2545ZBjorn-Roli Per Erik · Anchorage, AKBuilt 1963 · S/N 185-0545 N25466Bas Part Sales LLC · Greeley, COBuilt 1986 · S/N E-2303 N2546CRaby Byrd J · Normandy, TNBuilt 1954 · S/N 26190 N2546KSkywagon 1 LLC · Boynton Beach, FLBuilt 1978 · S/N 18052981 N2546PDadez Jaime G · Browntown, WIS/N 22-2910 N2546RStephani Timothy Michael · White Lake, WIBuilt 1967 · S/N 18258246 N2546UL00 Fliers LLC · Lewes, DEBuilt 1979 · S/N 28-8016033 N2546ZClark Brent R · Layton, UTBuilt 1977 · S/N 998-77 N25471Cottingham Lon W · Kingwood, TXBuilt 1940 · S/N 1 N2547GHiebert Franz · Seminole, TXBuilt 1959 · S/N 51847 N2547HThree S Ranch · Blanca, COBuilt 1979 · S/N 18-7909198 N2547QLawrence Thomas C · Memphis, TNBuilt 1977 · S/N 28-7725200 N2547WBittorf Charles Shane · Clear Lake, WIBuilt 1974 · S/N MC-255 N2547XOber John A · Candor, NYS/N P206-0047 N2547ZLecompte Francesca · Lancaster, MABuilt 1978 · S/N 261-78 N2548GWells Kenneth B · Fort Myers, FLBuilt 1959 · S/N 51848 N2548QChristian Keith · Lighthouse Point, FLS/N 28-7716110

Back to AD 2007-04-19 R1