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.

N20218Emporia Flying Club Inc · Emporia, KSBuilt 1972 · S/N 17261104 N20219Koenitzer Judson B · Chetek, WIS/N 17261105 N2021CPray Aviation Inc · Augusta, KSBuilt 1959 · S/N TD-212 N2021EEagle Home Medical Corp · Roanoke Rapids, NCBuilt 1978 · S/N D-10158 N2021LNiehaus James O · Erie, COBuilt 1967 · S/N 354 N2021RYergers Garage LLC · Leesport, PABuilt 1969 · S/N 28-5429 N2021UAll Airline Pilot Training LLC · Delray Beach, FLBuilt 1978 · S/N TH-957 N20223Roberts Stephen Wade · Friendswood, TXBuilt 1977 · S/N 17702648 N20224Obie Aviation LLC · Rogers, ARBuilt 1978 · S/N D-10159 N20225N20225 LLC · Pottsboro, TXBuilt 1972 · S/N 17261110 N20226Morris Aero Club · Towaco, NJBuilt 1972 · S/N 17261111 N2022CCarriere James M · Navarre, FLBuilt 1959 · S/N TD-189 N2022NKauffman Jeffrey B · Leominster, MABuilt 1978 · S/N E-1334 N2022TAero-Marine LLC · Miramar Beach, FLBuilt 1978 · S/N TH-950 N2022WStadelmann Joseph P · Milton, MABuilt 1965 · S/N D-7968 N20230Cessna 20230 LLC · Windsor, CABuilt 1972 · S/N 17261115 N20232Lopez Tail Draggers LLC · Lopez Island, WABuilt 1972 · S/N 17261116 N20233Jenkins Robert W · Fredericktown, OHBuilt 1972 · S/N 17261117 N20234Emaw Properties LLC · Ketchum, OKBuilt 1978 · S/N CE-801 N20236Safety In Motion Flight Center Inc · Puyallup, WAS/N 17261120 N20238Valenti Jeffery N · Eastport, NYBuilt 1973 · S/N 17261122 N2023ASouthern Cast Products Inc · Meridian, MSBuilt 1978 · S/N TC-2168 N2023CFulps Aviation LLC · Winston Salem, NCBuilt 1979 · S/N TH-1012 N2023KJuliet Foxtrot LLC · Scott City, KSBuilt 1978 · S/N TC-2169 N2023LStearns Ramsey Aviation LLC · Brooten, MNBuilt 1978 · S/N CE-802 N2023RWhitehurst Brian P Trustee · Crossville, TNBuilt 1969 · S/N 28-5430 N2023WSpecialty Extrusion Marketing Co Inc · Dover, DEBuilt 1965 · S/N TC-971 N2023XZim Sim LLC · Charleston, SCBuilt 1965 · S/N 18256123 N2023ZSchulert Peter · Lebanon, TNS/N TC-2171 N20241Aviation 241 Inc · North Lima, OHBuilt 1972 · S/N 17261124 N20242Gent John F · Wellman, IABuilt 1972 · S/N 17261125 N20243Webb John W · Elkins, WVBuilt 1972 · S/N 17261126 N20246Olek Brad · New Richmond, WIBuilt 1972 · S/N 17261127 N20247Grace Ellen M · Bloomville, NYBuilt 1972 · S/N 17261128 N2024ANew Heights Aviation LLC · Waxhaw, NCFirst renewal noticeBuilt 1978 · S/N CE-804 N2024CD M S Leasing Co LLC · Las Vegas, NVBuilt 1959 · S/N TD-198 N2024EJoslyn Larry J · Las Vegas, NVBuilt 1996 · S/N S1734 N2024GPerry Scott D · Hood River, ORBuilt 1978 · S/N D-10162 N2024KB2s Aviation LLC · Billings, MTBuilt 1978 · S/N D-10164 N2024PYounhorsh Sales LLC · Wilmington, DEBuilt 1956 · S/N 24-1 N2024QFoose John L Trustee · Sammamish, WABuilt 1978 · S/N E-1339 N2024RStorm David A · Lowell, ARBuilt 1969 · S/N 28-5432 N2024SRegistration Pending · Sublette, KSRegistration pendingS/N R18201285 N2024VWhiskey Tango Flyers Inc · Middletown, DEBuilt 1978 · S/N D-10165 N2024WMunn Jeffrey R · Auburn, NYBuilt 1966 · S/N D-8078 N2024XMahaney Nicholas · Tahlequah, OKBuilt 1965 · S/N 18256124 N20250Kooistra Samuel R · Honobia, OKBuilt 1972 · S/N 17261131 N20251Granahan Eric J · Burlington, WIBuilt 1972 · S/N 17261132 N20252Morino William D · Palos Verdes Est, CABuilt 1981 · S/N 18053183 N20259Mackin Robert Michael · Castro Valley, CABuilt 1972 · S/N 17261136

Back to AD 2007-04-19 R1