Skip to content

AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N12750Crosby Flying Services LLC · Fort Worth, TXBuilt 1973 · S/N 17262229 N12751Wyatt Trost LLC · Concordia, KSBuilt 1973 · S/N 17262230 N12753Juliett Papa LLC · Kalispell, MTBuilt 1973 · S/N 17262232 N12755Real Aviation Inc · Syracuse, NYS/N 21931 N12757Altitude Aviation Group LLC · Christmas, FLBuilt 1965 · S/N 28-20776 N1275BWeisgram Ted · Corbett, ORBuilt 1995 · S/N 1287 N1275JEllis Keith W · Springfield, MOBuilt 1975 · S/N 275 N12760Decker Stephen Lee · Como, COBuilt 1973 · S/N 17262235 N12766Civil Air Patrol Flying Assoc Inc · Branford, CTBuilt 1973 · S/N 17262240 N12767Lipstreu William H · Hudson, OHBuilt 1975 · S/N 17702386 N12768Martin Thomas J · Lynden, WABuilt 1973 · S/N 17262242 N1276GCarter Joseph C · Brookline, NHBuilt 1974 · S/N 310Q1126 N1276TShillieto Mark C · Wilmington, OHBuilt 1972 · S/N 28-7225393 N1276UStelham Co · Olive Branch, MSBuilt 1976 · S/N 17266971 N1276VNew Horizon Aviation Inc · Warwick, RIBuilt 1984 · S/N T30300262 N12772Bell Ornithopters Flying Club Inc · Eastlake, COBuilt 1973 · S/N 17262245 N12776Oviedo Juan · Oak Point, TXBuilt 1973 · S/N 17262249 N12777Mana Kai Flying LLC · Makawao, HIBuilt 1973 · S/N 17262250 N12779Mile High Flyers Club Inc · Fort Valley, VABuilt 1973 · S/N 17262252 N1277FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17272982 N1277WRush Aviation Rentals Inc · Meridian, IDBuilt 2001 · S/N 172S8846 N1277XDuke City Mooney LLC · Lakewood, COBuilt 1963 · S/N 150 N1277ZKnight Donald R · Merrimack, NHBuilt 1961 · S/N CD-342 N127826350 LLC · Yorklyn, DES/N 17702387 N12783American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262256 N12789Marshall Frederic J · Rochester, NYBuilt 1973 · S/N 17262261 N1278JBallester Alexis R · Mayaguez, PRBuilt 1975 · S/N 278 N1278SSac Exec LLC · Sacramento, CABuilt 1976 · S/N 18264846 N1278TSmith Sullivan · Cookeville, TNBuilt 1972 · S/N 28-7225447 N12790Cdb Group Holdings LLC · Sheridan, WYBuilt 1973 · S/N 17262262 N12791Neo Flites Flying Club Inc · Elmhurst, ILBuilt 1973 · S/N 17262263 N12793Arpey Gerard J · Colleyville, TXBuilt 1973 · S/N 17262264 N12794Mccain Michael G · Barstow, CABuilt 1973 · S/N 17262265 N12795Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17262266 N12796Skylens LLC · Hammond, LABuilt 1973 · S/N 17262267 N1279GHodgman Gary W · Greenville, TXBuilt 1974 · S/N 310Q1129 N1279MSturdy Wings Aviation LLC · Mcpherson, KSBuilt 1975 · S/N 18264272 N1279RSedona Aviation LLC · Sedona, AZS/N 30402 N1279SCavu Aviation LLC · Haiku, HIBuilt 1976 · S/N 18264847 N1279XRegistered aircraftBuilt 1963 · S/N 152 N127AKSwan Logistics LLC · Toledo, OHS/N 2059 N127ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496035 N127AVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 28-8490077 N127BNunneley Ian · Port Saint Joe, FLBuilt 1963 · S/N CD-607 N127BDRegistered aircraftBuilt 2022 · S/N 620-2022 N127BSDemaagd Aviation LLC · Hickory Corners, MIBuilt 2005 · S/N 29-0378 N127BZFox Systems Inc · Calhoun, GABuilt 2019 · S/N E-4127 N127CFGeorgia Forestry Commission · Macon, GABuilt 2007 · S/N 18282027 N127CGRegistered aircraftBuilt 2025 · S/N 41976 N127CPHatfield David E Trustee · Bangs, TXBuilt 2001 · S/N 18065C

Back to AD 2007-04-19 R1