Skip to content

AD 2007-04-19 R1

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.

N251EXJames Jonathan K · Stillwater, MNBuilt 2025 · S/N 7352 N251GJendair LLC · New York, NYBuilt 1977 · S/N 61P-0462-181 N251GT251gt Corp · Oak View, CAS/N CD-251 N251HFHaidar Aviation LLC · Dallas, TXBuilt 2025 · S/N JP001 N251HPKoch & Koch Inc · Grass Valley, CABuilt 1982 · S/N 172RG1124 N251JBVan Horne Robert E · Centralia, ILBuilt 1965 · S/N 21 N251LFTja Aviation LLC · Miami, FLBuilt 2007 · S/N 11847 N251MANorris Suzanne W · Howe, IDBuilt 2003 · S/N 1346-2003 N251MECavu Aircraft Group LLC · Green Cove Springs, FLBuilt 2000 · S/N 18280740 N251MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881443 N251NDKasowski Flint · Buffalo, NDBuilt 1998 · S/N 2842042 N251RDidier Christopher W · Fay, OKBuilt 1972 · S/N 61139 N251RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266249 N251RBNewton Roger N Jr · Marrero, LABuilt 1984 · S/N 408 N251RGBunn Mary · Williamstown, WVBuilt 2008 · S/N 089 N251RXPlane Therapy LLC · Hudson, FLBuilt 1978 · S/N AA5A0545 N251SFCgc Prop Plane 1 LLC · Metairie, LABuilt 2025 · S/N 172S13444 N251TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020241 N251TLTlh-1 LLC · Anchorage, AKBuilt 2015 · S/N 13818 N251TTTyson David · Lusk, WYBuilt 1997 · S/N 25013C N251WCThyssen Patrick L · Conroe, TXBuilt 2000 · S/N 424-2000 N251WFWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 287990548 N251WHTallmadge Brian · Prescott, AZBuilt 1994 · S/N 3251 N251WYNorton Robert · Coeur D Alene, IDBuilt 2015 · S/N 3251 N251YAnderson Michael A · Bowie, MDBuilt 2021 · S/N M-II-2510 N25200Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13385 N25204Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13387 N25205Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13390 N25208Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13393 N2520GGrinch Aviation LLC · Madera, CABuilt 1959 · S/N 51820 N2520QRcmt Properties LLC · Havre, MTBuilt 1966 · S/N 18257720 N2520RWinston Douglas S · Star, IDBuilt 1967 · S/N 18258220 N25212Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13396 N25213Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13399 N25218Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13402 N25219Octopus Flying Club Inc · Riverdale, MDS/N 970 N2521GMountain Aviator LLC · Edwards, COBuilt 1959 · S/N 51821 N2521NOpen Heavens Aerospace LLC · Fort Gratiot, MIS/N 901 N2521RSok Gregory J · Wallingford, CTBuilt 1969 · S/N 28-5641 N2521SSieberts Soren K · Anchorage, AKBuilt 1979 · S/N 18-7909152 N2521TMoore Kevin B · Lancaster, VABuilt 1968 · S/N NAV-4-2519 N2521UN2521u LLC · Danbury, CTBuilt 1979 · S/N 28-8016029 N2522Garella Craig W · Edwardsville, ILBuilt 2020 · S/N 42006 N25220Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13405 N2522APierce Stephan L · Graham, TXBuilt 1953 · S/N 22-830 N2522BRossman Brian · Valparaiso, INS/N 863 N2522PPfisters Helicopters Inc · Pasco, WABuilt 2014 · S/N 2352 N2522QJohnson Sales & Service Inc · Ong, NEBuilt 1966 · S/N 18257722 N2522RPechanec Brent L · Wichita, KSBuilt 1967 · S/N 18258222 N2522TLemons Lawson W · Crowell, TXBuilt 1967 · S/N NAV-4-2504

Back to AD 2007-04-19 R1