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.

N206YSPalmer Ronald Everett Trustee · Hopkington, NHBuilt 1979 · S/N U20604652 N206ZB16d LLC · Vashon, WABuilt 2006 · S/N 20608276 N20706Ahf Investments LLC · Ruston, LABuilt 1972 · S/N 18261142 N20707Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12562 N20708Viersen Leonard J Trustee · Glennallen, AKBuilt 1972 · S/N 18261144 N20709Superior Fresh LLC · Idaho Falls, IDBuilt 1972 · S/N 18261145 N2070GAerobus LLC · Des Moines, IABuilt 1958 · S/N 51370 N2070KRudy Schmitt · Brookshire, TXBuilt 1964 · S/N 206-0196 N2070LBaron 70 Lima LLC · Modesto, CABuilt 1976 · S/N TH-753 N2070MD&L Aviations LLC · Breckenridge, TXBuilt 1977 · S/N 28-7890226 N2070SThompson Robert V Trustee · Crawford, COBuilt 1975 · S/N 21061037 N2070WLeisure Air II LLC · Columbus, GABuilt 1965 · S/N TC-974 N2070XNrt LLC · Maple Valley, WAS/N 18256170 N20711Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12563 N20713Spradling Tommy G Jr · Campbell, TXBuilt 1972 · S/N 18261148 N20714All American Aviation Services Inc · Wilmington, NCS/N 17263816 N20716Sargent Philip R · North Scituate, RIBuilt 1974 · S/N 17263817 N2071BTrulson Gary S · Edgerton, WIBuilt 1978 · S/N M-2099 N2071GGroarke Michael J · Marion, MTS/N 51371 N2071LDelong Scott R · Punta Gorda, FLBuilt 2004 · S/N 70412 N2071PAviation Business Corp · Saint Louis, MOBuilt 1956 · S/N 23-658 N2071RHughes Audie D · Starkville, MSS/N 28-5452 N2071WCountry Sunset LLC · Mc Louth, KSBuilt 1966 · S/N CD-987 N2071YRossiter Brahm J · Lemoore, CABuilt 1997 · S/N E-3120 N20725Smith James M · Burbank, WABuilt 1972 · S/N 18261157 N20727Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12577 N20729Di Ludovico Leonard P · Leetonia, OHBuilt 1974 · S/N 17263821 N2072GMccullough Russell O · Carson, CABuilt 1958 · S/N 51372 N2072SKelty Joel P · Portland, ORBuilt 1979 · S/N R18201298 N2072TAshby Darrell · Elko, MNBuilt 1970 · S/N 28R-7135016 N2072WNewsome Jeff · Blackwell, OKBuilt 1965 · S/N D-8001 N2072YDietz Michael · Big Lake, AKBuilt 1989 · S/N 89-2001 N20730Tantiyatyanon Preeda · Flagstaff, AZBuilt 1972 · S/N 18261162 N20734Galegor Samuel T · Pleasant Hill, MOBuilt 1974 · S/N 17263822 N20735Porter H Tom · Columbia, MSBuilt 1972 · S/N 18261165 N20738Acquafly Creation LLC · Apopka, FLS/N 18261168 N2073EGreat Lakes Air Ventures LLC · Mason, MIBuilt 1978 · S/N 17271144 N2073GShepard Brothers LLC · Columbia, MSBuilt 1958 · S/N 51373 N2073LBravo Wings II LLC · Grants, NMBuilt 1976 · S/N TJ-73 N2073RWindler Steven D · Owasso, OKBuilt 1964 · S/N 18255273 N2073TMcguire Guy D · Stevensville, MDBuilt 1970 · S/N 28R-7135017 N2073WPlowden William E Jr · Shelby, NCBuilt 1965 · S/N D-8003 N2073XAnania Nickolas F · West Ossipee, NHBuilt 2000 · S/N 2073 N20740Registered aircraftBuilt 1972 · S/N 18261170 N20742Iowa Lakes Community College · Estherville, IABuilt 1974 · S/N 17263825 N20743Eagles Flight LLC · Grove, OKBuilt 1972 · S/N 18261172 N20745Van Wert County Regional Airport Authority · Van Wert, OHBuilt 1974 · S/N 17263826 N20747Above And Beyond Aviation LLC · Austin, TXBuilt 2020 · S/N 172S12578 N20748Registration Pending · Bethesda, MDRegistration pendingBuilt 1978 · S/N M-2077 N2074AN2074a Aviation LLC · Sheridan, WYBuilt 1968 · S/N 17257138

Back to AD 2007-04-19 R1