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.

N24249Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13149 N2424ABarnard Brian · Tallahassee, FLBuilt 1993 · S/N 1809075 N2424FPerformance Aviation Services LLC · Belmont, OHBuilt 1964 · S/N 28-2117 N2424HAtom Air LLC · Creekside, PABuilt 2023 · S/N 1 N2424Q24q Inc · Cedar City, UTBuilt 1966 · S/N 18257624 N2424RCurlee Derek · Yoakum, TXBuilt 1964 · S/N 18255524 N2424TWhiskey Fox Inc · Kearney, NEBuilt 1962 · S/N NAV-4-2424 N2424VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1972 · S/N 28-7225586 N24251Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13150 N24256Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13151 N24257Career Track I LLC · Wilmington, DEBuilt 2024 · S/N 172S13152 N24258Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13153 N24259Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13154 N2425AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496252 N2425CGiovanini Terry L · Bozeman, MTBuilt 1979 · S/N 18267471 N2425GMccune Charles · Metamora, ILBuilt 1959 · S/N 51725 N2425MTap Solutions Inc · San Diego, CABuilt 1977 · S/N 28-7816283 N2425RDietze Weldon W · Seguin, TXBuilt 1964 · S/N 18255525 N2425SPark Sung S · Marana, AZBuilt 1976 · S/N 21061276 N2425TIowa Valley Aviation Inc · Oxford, IABuilt 1964 · S/N NAV-4-2425 N24262Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13156 N24263Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13157 N24265Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13158 N24267Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13160 N24268Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13161 N2426JLewis Chad · Anchorage, AKBuilt 1979 · S/N 18-7909122 N2426RRiley Aerospace LLC · Sebastian, FLBuilt 1964 · S/N 18255526 N2426TDowden Frank D · Fallbrook, CABuilt 1962 · S/N NAV-4-2426 N2426XColwell Patrick R Jr · Medford, WIBuilt 1965 · S/N 18256326 N2427DWiplinger Charles · Inver Grove, MNBuilt 1979 · S/N 18-8009007 N2427GMcneil Jesse M · Central, AKBuilt 1959 · S/N 51727 N2427M18 Rwy LLC · Falmouth, MEBuilt 1977 · S/N 28-7816284 N2427RFalcon Flight Squadron Inc · Los Angeles, CABuilt 1969 · S/N 28-5620 N2427TNilson Henry A Trustee · Holtville, CABuilt 1962 · S/N NAV-4-2427 N2427UGalante Anthony R · Saint Clair, MIBuilt 1979 · S/N 28-8090044 N24280Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13183 N24281Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13185 N24283Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13186 N24285Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13188 N2428BZahler Mitchell J · Stillwater, MNBuilt 1949 · S/N 3728 N2428CRegistered aircraftBuilt 1954 · S/N 30728 N2428EHusel Robert · Bend, ORBuilt 2005 · S/N 1307 N2428GBackcountry Guys LLC · Prescott, AZBuilt 1959 · S/N 51728 N2428PHill Tim E · Russellville, ARBuilt 1970 · S/N 39-64 N2428RAltimeter Inc · San Marcos, TXBuilt 1964 · S/N 18255528 N2428TDavis John J · Anderson, SCBuilt 1962 · S/N NAV-4-2428 N2428XBiggs Clifford G · Washington, UTBuilt 1965 · S/N 18256328 N2429EByrd David Phillip · King Salmon, AKBuilt 1966 · S/N 185-1172 N2429GSkydive Florida Keys Inc · Summerland Key, FLS/N 51729 N2429JWolf Gary P · Pahrump, NVBuilt 2001 · S/N 5123

Back to AD 2007-04-19 R1