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.

N250FMParagon Airplane Leasng Co · Fort Myers, FLBuilt 2022 · S/N 28020100 N250GWasalo And Luby Air LLC · La Fayette, GABuilt 1967 · S/N D-8600 N250GCCarroll James E Trustee · Newington, NHBuilt 1977 · S/N 18266130 N250GTComanche Golf Tango LLC · Clifton, VAS/N 24-2496 N250JBGuy Jeffrey · Centerburg, OHBuilt 1981 · S/N A-109 N250JFSnapp Michael D · Portland, ORBuilt 1997 · S/N 644-320-389 FB N250JGGross Jeffrey M · Bastrop, TXBuilt 2005 · S/N 81185 N250LMenefee Scott A · Los Banos, CABuilt 1979 · S/N R18200936 N250LJCarew Aviation Inc · Appleton, WIBuilt 1964 · S/N 24-3393 N250LSIszak Lenard A · Palm City, FLBuilt 1991 · S/N 0063 N250MPray Aviation Inc · Augusta, KSS/N TD-625 N250MALc Flyers LLC · Monument, ORBuilt 2003 · S/N 2243 N250MGAkin Kent Trustee · Midland, TXBuilt 1980 · S/N 0005-80 N250MLAlpha Aero Repair LLC · Dousman, WIBuilt 1973 · S/N CE-475 N250MMMone Forwarding Lc · Laredo, TXBuilt 1980 · S/N TJ-261 N250MPJohanson Jason · Groveland, CAS/N 010 N250PCHerndon Timothy M · Kingston, OKBuilt 1959 · S/N 24-1133 N250RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266043 N250RBWestern Slope Aviators LLC · Delta, COBuilt 1958 · S/N 24-334 N250RTMatthews Aviation LLC · Hardinsburg, KYBuilt 1971 · S/N 27-4681 N250SBInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N SW27 N250SPInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 70 N250SUOklahoma State University · Stillwater, OKBuilt 2016 · S/N 172S11675 N250TJTalley John T · Clifton, TXBuilt 1959 · S/N 24-1048 N250WFGita Aviation LLC · Dallas, TXBuilt 1978 · S/N 28-7916088 N250WYBrawley David N · Fort Wayne, INBuilt 2015 · S/N 3250 N250YMyers Mark E · Rogers, ARBuilt 1966 · S/N CD-1065 N250YZAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11608 N250ZMedic Choppers LLC · Springdale, ARBuilt 2018 · S/N 1223 N250ZHHatzenbeller James M · Saint Francis, WIBuilt 2017 · S/N 5582 N25104Kantorowicz Jon C · Great Falls, MTBuilt 1977 · S/N 2501 N2510AIlgenfritz Don C Jr · Fairbanks, AKBuilt 1952 · S/N 18-1974 N2510HErickson Paul C · Alexandria, MNBuilt 1979 · S/N 18-7909197 N2510KFugate Sandra S · Louisville, KYBuilt 1989 · S/N 877 N2510MYonder Corp · Wilmington, DEBuilt 1979 · S/N 27-7954070 N2510TN2510tango LLC · Corona, CABuilt 1968 · S/N NAV-4-2510 N2510XRegistration Pending · West Hartford, CTRegistration pendingBuilt 1985 · S/N 32-8606001 N2510ZCherry Hill Aviation Inc · Freetown, INBuilt 1977 · S/N 256-77 N25110Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13287 N25111Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13290 N25112Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13293 N25113Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13296 N25114Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13298 N25115Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13299 N25116Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13300 N2511798x LLC · Caddo Mills, TXBuilt 1970 · S/N 17259514 N25118Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13302 N2511DDfs2024 LLC · Edwards, COBuilt 1979 · S/N 18266873 N2511RDickey Mark D · Pendleton, ORS/N 18258211 N2511WArcher Ht LLC · Noblesville, INBuilt 1973 · S/N MC-172

Back to AD 2007-04-19 R1