AD 2007-04-19 R1

Registered aircraft · 108,434

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
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.

N358YJuliet Air LLC · Cincinnati, OHS/N TH-1551N358ZMcrae Auto Corp · Jacksonville, TXBuilt 1960 · S/N CD-240N35909Flight1 Hsw LLC · Norwood, COBuilt 1975 · S/N U20602792N3590AHill Lonnie R · Gainesville, GABuilt 1969 · S/N TC-1312N3590PSoyars Thomas E · San Marcos, TXBuilt 1955 · S/N 18-4545N3590WAgoston Thomas M Trustee · Liberty Twp, OHBuilt 1966 · S/N 32-485N3590YAlexander Macy Nix · Mineral Wells, TXBuilt 1963 · S/N 18254490N3591FWolfe Robert G · West Columbia, SCBuilt 1970 · S/N 17259225N3591NPeperuka LLC · Olympia, WABuilt 1967 · S/N 680108N3591RAwmr LLC · Conroe, TXBuilt 1970 · S/N 28-5704N3592FArey Peter W · Great Falls, VABuilt 1966 · S/N 18257592N3592KBeckler Benjamin C · Middle Granville, NYBuilt 1967 · S/N 28-23647N3592PDengler Steven G · Lopez Island, WABuilt 1955 · S/N 18-4550N3592QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1973 · S/N 17261692N3592RBurnt Ridge LLC · Kalispell, MTBuilt 1969 · S/N 28-5705N3592WFoothills Aviation Inc · Pickens, SCBuilt 1966 · S/N 32-488N3592XBryant David Wayne · Ada, OKBuilt 1968 · S/N 680161N3592YArcher Donald B · Artesia, NMBuilt 1962 · S/N 18254492N35932Tmzk Holdings LLC-1 · North Fort Myers, FLBuilt 1975 · S/N U20602808N35937Glaser Don E DBA · Willow, AKFirst renewal noticeBuilt 1975 · S/N U20602812N3593FEakin Robert C · Franklin, PABuilt 1970 · S/N 17259400N3593QKettunen Alan C · Ashtabula, OHBuilt 1973 · S/N 17261693N3593UBdg Holdings Inc · Kingston, PABuilt 1969 · S/N 18259866N3593WGriffin Julie A · Locust Grove, GABuilt 1966 · S/N 32-489N35945Illinois Department Of Transportation · Springfield, ILBuilt 1975 · S/N U20602819N35947Continental Construction Inc · Alpine, WYBuilt 1975 · S/N U20602821N3594AFlying Fur Animal Rescue · Kintnersville, PABuilt 1969 · S/N D-9072N3594FFirst Flight Corp · San Diego, CABuilt 1966 · S/N 18257594N3594JWxs Flying LLC · Mesa, AZS/N 32-7840095N3594QGribble Ted A · Paris, TXBuilt 1973 · S/N 17261694N35952Johnson Deborah K · Fairbanks, AKBuilt 1974 · S/N U20602825N35957Cortez Flying Service Inc · Cortez, COBuilt 1975 · S/N U20602829N3595ALogistics Consulting LLC · Wilmington, DEBuilt 1969 · S/N TE-776N3595PSchumacher Craig A · Fairbanks, AKBuilt 1955 · S/N 18-4553N3595UBrinkman Eric · Phoenix, AZBuilt 1963 · S/N 18254995N3595WStanley Shawn G · Lorton, VABuilt 1966 · S/N 32-491N3595ZJohnson Issac · Krugerville, TXBuilt 1960 · S/N 18-7388N35962Barker Aviation LLC · Spearfish, SDBuilt 1975 · S/N U20602833N3596KStall Breakers LLC · Sachse, TXBuilt 1967 · S/N 28-23648N3596WAbdelqader Hamza Faris · Beaufort, SCBuilt 1966 · S/N 32-492N3596YHeintz Ludwig C · Covington, LABuilt 1962 · S/N 18254496N3597EBlue Bird Aero Club Inc · Bonne Terre, MOBuilt 1978 · S/N 17271601N3597FLivesay John · Pana, ILBuilt 1966 · S/N 18257597N3597KQuinn Knives LLC · Julian, CABuilt 1967 · S/N 28-23649N3597PBickford Tierra L · Big Lake, AKBuilt 1955 · S/N 18-4555N3597YCraig & Craig LLC · Merrillville, INS/N 18254497N3598UDunn Mark · Visalia, CABuilt 1963 · S/N 18254998N3598WSwiss Eagles Inc · Las Vegas, NVBuilt 1966 · S/N 32-495N3599HSitter Duane A · Hayward, CABuilt 1977 · S/N 20-1238N3599YLooker Daniel M · Ferndale, WABuilt 1962 · S/N 18254499
Back to AD 2007-04-19 R1