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.

N130HLFair Winds Aviation LLC · Shreveport, LABuilt 1979 · S/N 414A0322 N130JAHagele Aviation LLC · Hillsboro, ORBuilt 2002 · S/N 172S9165 N130JMRegistration Pending · Tampa, FLRegistration pendingBuilt 1982 · S/N 28-8390036 N130KSouthern Aircraft Consultancy Inc Trustee · NorfolkRegistration ineffective or invalidBuilt 1978 · S/N 32R-7885109 N130KWClemente Daniel L · Manheim, PABuilt 2014 · S/N 90301 N130MEPetersens Marine Services Corp · Ridge, NYBuilt 2000 · S/N 18280686 N130MMMighty Mike LLC · Maysville, KYBuilt 1964 · S/N 30-550 N130MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2019 · S/N 4496477 N130PJLindholm Dow W · Masury, OHS/N 21572 N130PMMccurry Terry D · Greenwood, SCBuilt 2010 · S/N 22894 N130PRPuerto Rico Police Department · San Juan, PRS/N TH-2338 N130RACarter Distribution Lc · Salt Lake City, UTBuilt 1976 · S/N 340A0040 N130RCWilliams Brian G · Las Cruces, NMBuilt 1983 · S/N P21000822 N130RNPrewitt Blake S · Prescott, AZS/N 20275 N130RRAllbritten Jeffrey P · Winder, GAS/N 2841264 N130SKCity Of Lakewood · Lakewood, CABuilt 2007 · S/N 11781 N130SRLimitless Aviation And Adventures LLC · Tomball, TXBuilt 1994 · S/N 1642 N130TCVogt Richard L · Panama City Beach, FLBuilt 1976 · S/N 18264999 N130THDelage Jeffrey R · Biddeford, MEBuilt 1977 · S/N AA5A0398 N130VUSwords Kyle · New Albany, MSBuilt 1975 · S/N 180-75 N130WLBlake Larry Q · Cleveland, GABuilt 1986 · S/N 130 N130YDBoyd William E Jr · Clifton Forge, VAFirst renewal noticeBuilt 2020 · S/N 41154 N130YSBuntin David P · Bethpage, TNBuilt 2011 · S/N 81209 N130YYMatejka Jeff · Maple, NCBuilt 2000 · S/N 21873 N130ZKrueger Mark A · Anchorage, AKBuilt 2001 · S/N 01 N13100Ruttenberg Barbara A · Lexington, KYBuilt 1973 · S/N 17262494 N13101North Hollywood Optimist Club Youth · Van Nuys, CABuilt 1973 · S/N 17262495 N13104Erley Robert B · Kirkland, WABuilt 1973 · S/N 17262498 N13108Registered aircraftBuilt 1976 · S/N 17702398 N13109Illinois Valley Flying Club · Peru, ILBuilt 1973 · S/N 17262503 N1310AKoep Evan T · Brookings, SDBuilt 1967 · S/N CD-1105 N1310CGraupman Gerald · Chicago, ILBuilt 1981 · S/N TW-1 N1310JRock Nh Services LLC · Alpine, TXS/N 310 N1310KVector Aviation LLC · Mentor, OHBuilt 1976 · S/N 28-7790216 N1310UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020247 N13115Kkmjj LLC · South Lyon, MIBuilt 1973 · S/N 17262507 N13117Mccullough James R · Newville, PABuilt 1973 · S/N 17262509 N13119Boomer Aviation LLC · Catoosa, OKBuilt 1973 · S/N 17262511 N1311GGranite Mountain Flight Training LLC · Prescott, AZBuilt 1974 · S/N 310Q1152 N1311JBranch Turley Camille A · Wilmington, DEBuilt 1975 · S/N 311 N1311SCutlass 661 LLC · Orange Park, FLBuilt 1976 · S/N 18264876 N13127Fisher Global LLC · Conway, ARBuilt 1973 · S/N 17262517 N13128Huffman David L · Corsicana, TXBuilt 1976 · S/N 17702400 N13129Giartlau Aviation Corp · Minneola, FLBuilt 1973 · S/N 17262519 N1312ABowen Haldor S · Sandpoint, IDBuilt 1951 · S/N 18-1114 N1312EBuswell Aviation Inc · Salem, ORBuilt 1978 · S/N 17270950 N1312SMid Valley Aviation LLC · Groveland, CAS/N 18264877 N1312USimplifly LLC · Mesa, AZBuilt 1976 · S/N 17267001 N1312WKing Scott W · Tampa, FLBuilt 1963 · S/N 200 N1313Cochrane Timothy A · Chippewa Lake, OHS/N 1809013

Back to AD 2007-04-19 R1