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.

N1501ZDaytona Aircraft Services Inc · Daytona Beach, FLBuilt 1961 · S/N D-6824 N15021Brandywine Flight School · West Chester, PABuilt 1972 · S/N 28R-7235319 N15022Registration Pending · Riverside, CARegistration pendingBuilt 1972 · S/N 28R-7335001 N15024Whytes Inc · Coconut Creek, FLBuilt 1972 · S/N 34-7250349 N15027Mallue Jeff · Springboro, OHBuilt 1972 · S/N 28R-7235320 N1502EElizbeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9900 N1502RSale Reported · San Diego, CASale reported, pending cancellationBuilt 1974 · S/N AA5B-0002 N1502SMakiva Sasha · Sonoma, CAS/N D-6899 N1502ZSmith Chad M · Danville, CABuilt 1961 · S/N D-6823 N15032Ross Adam D · Bixby, OKBuilt 1972 · S/N 28-7225555 N15034Pathfinder Aviation Services LLC · St Johns, FLBuilt 1972 · S/N 28-7225557 N15035Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250353 N15037Ace Aircraft Leasing Inc · Nazareth, PABuilt 1972 · S/N 28-7225560 N1503RBeck Wally J · Davenport, IABuilt 1974 · S/N AA5B-0003 N1503UAmerican Jet Center Inc · Chino, CABuilt 1973 · S/N U20602228 N1503XGasoline Valley LLC · Clyde, MIS/N 28-7525324 N1503ZMain Attraction LLC · Sioux Falls, SDBuilt 1961 · S/N D-6825 N1504AHise Kevin E · Rock Rapids, IABuilt 1951 · S/N 20-688 N1504JRuminski Pamela S · Salesville, OHBuilt 1967 · S/N 28-23897 N1504RFlying Tiger LLC · Broomfield, COBuilt 1974 · S/N AA5B-0004 N1504TChavez David L · Cedar Park, TXBuilt 1972 · S/N 28-7225500 N1504VCulman William A · Scotts Valley, CABuilt 1974 · S/N 17263633 N1504XVerge Aeronautics LLC · Charlotte, NCBuilt 1975 · S/N 28R-7535301 N15050Houston William W · Baltimore, MDBuilt 1972 · S/N 28-7225569 N15057Bad Dog Aviation · Meridianville, ALBuilt 1972 · S/N 28-7225572 N1505SBluboco LLC · Northville, MIBuilt 1962 · S/N D-7037 N1505XFarrell Donald A · Owasso, OKBuilt 1975 · S/N 28R-7535302 N1505ZKc Air LLC · Wellford, SCBuilt 1962 · S/N CD-542 N15064Kropp Christian Owner Trustee · Azle, TXS/N 34-7350005 N15066Cherokee Aviation Group LLC · Alpharetta, GABuilt 1972 · S/N 28-7225577 N1506JHumbles Frank Forrest · Charleston, SCBuilt 1976 · S/N 13003 N1506MBonn Steven · Hummelstown, PABuilt 1975 · S/N 18264356 N1506TWaldrep Zoey V · Tampa, FLS/N 28-7225538 N1506VDeshon Loren · Friday Harbor, WABuilt 1974 · S/N 17263634 N1506ZTopspeed Black LLC · Alpharetta, GABuilt 1961 · S/N CD-395 N15079Rea Robert III · Bumpass, VABuilt 1972 · S/N 28-7225585 N1507EGonzalez Moya Camilo Rafael · Fort Worth, TXBuilt 1978 · S/N 17271028 N1507SArteta David A · Wake Forest, NCFirst renewal noticeBuilt 1962 · S/N D-6935 N1507TAero Care Inc · Orange, MABuilt 1972 · S/N 28-7205310 N1507XGolf November Aero LLC · Sunnyvale, CABuilt 2005 · S/N 172S9903 N15089Tusla Technology Center School District #18 · Tulsa, OKS/N 34-7350018 N1508CHutchings Alan J · Clewiston, FLBuilt 1953 · S/N 30208 N1508FHaley Wayne C · Okeechobee, FLBuilt 1964 · S/N 1850816 N1508JLiwag Reynaldo T Jr · Niagara Falls, NYBuilt 1967 · S/N 28-23901 N1508RAmspoker David A · Kingman, AZBuilt 1975 · S/N AA5B-0030 N1509CHammerquist Blake T · Benicia, CABuilt 1954 · S/N 30882 N1509FDragonfly Helicopter Service Ltd · North Dighton, MABuilt 2005 · S/N 0213 N1509MChalk 2 Inc · Apple Valley, CABuilt 1975 · S/N 18264357 N1509ZHeinrich John W · Chandler, AZBuilt 1961 · S/N TC-210 N150AAReed Aviation Inc · Iota, LABuilt 1972 · S/N AA1A-0394

Back to AD 2007-04-19 R1