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.

N444KCEdelman Douglas M · Sabetha, KSBuilt 1973 · S/N 28-7325504N444KPPerkins Kevin J · Wichita Falls, TXBuilt 2014 · S/N 92069N444KRSmith Wylie J · Hawthorne, FLS/N 690068N444KTHangar G-1 Aviation Partners LLC · Los Olivos, CABuilt 1981 · S/N 340A1235N444KWRaw Racing Inc · Puyallup, WAS/N 340A0241N444KY444 Dd LLC · Chavies, KYBuilt 2018 · S/N TH-2497N444LCPiper Cherokee LLC · Leesburg, VABuilt 1977 · S/N 32-7740047N444LJDsl Aviation LLC · Ronkonkoma, NYBuilt 1978 · S/N 310R-1294N444LLWolfson Alan B · Loveland, OHBuilt 1962 · S/N 18254063N444LMHumphrey William E · Lyndonville, VTBuilt 1966 · S/N 28-22118N444LSTaa Property LLC · Lake Wales, FLBuilt 1973 · S/N 414-0460N444LWWinn Larry V · Tucson, AZBuilt 1998 · S/N 2163N444MAFirst Order Aeronautics LLC · Lees Summit, MOBuilt 2002 · S/N 1HUN444MFChampagne Cruises Ltd · St Thomas, VIBuilt 2002 · S/N 0174N444MGGeorgia Aviation Authority · Eastman, GABuilt 2023 · S/N 4496562N444MLBarrett James P · Calistoga, CABuilt 2007 · S/N 11593N444MMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1989 · S/N MM1N444MTBill Mcgowan Inc · Covington, LABuilt 1974 · S/N 2079N444NCCharlie Papa LLC · Van Nuys, CABuilt 2007 · S/N 11786N444NWRegistration Pending · Mill Creek, WARegistration pendingBuilt 2009 · S/N 12585N444NXAce Aviation LLC · Mankato, MNBuilt 2000 · S/N 419-2000N444PFRegistered aircraftBuilt 1979 · S/N 543-79N444PGN444pg Aviation LLC · Charleston, SCBuilt 1998 · S/N E3218N444PHLansing Community College · Mason, MIBuilt 1990 · S/N 1578N444PJWagner Aviation LLC · Laura, OHBuilt 1974 · S/N 21060433N444PKRegistered aircraftBuilt 2005 · S/N 1364N444PPCoyne Greg · Hondo, TXBuilt 1969 · S/N 17258278N444PWMeyer Renee Brilhante · Lafayette, INFirst renewal noticeBuilt 1987 · S/N 12N444RDStrazza Nathanael P · Pearland, TXBuilt 1992 · S/N 92-21095RDN444REJenson Greg Ray · Pueblo, COS/N 55174N444RGKalasky Sean W · Jacksonville Beach, FLBuilt 1976 · S/N CE-644N444RHHelisafe Inc · Long Beach, CABuilt 1992 · S/N 0004N444RUFitzgerald Paul · Grapevine, TXBuilt 1973 · S/N D-9441N444RWBackus Gary Carl · Chesapeake, VABuilt 1979 · S/N 21063465N444SRr&D Lp · Fayetteville, NCBuilt 1985 · S/N TJ-490N444SAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250183N444SBN1849p LLC · Wilmington, DEBuilt 2008 · S/N E3844N444SFMerriman Larry L Jr · Anchorage, AKBuilt 2001 · S/N 25055CN444SKSpitzer Helicopter LLC · Woodland Hills, CABuilt 2003 · S/N 10114N444SLD And E Consulting LLC · Taylor, ARBuilt 1973 · S/N 28R-7335111N444SWChimisa Aviation LLC · Lake City, FLBuilt 2002 · S/N SW0142N444THealis William J · Scottsdale, AZBuilt 2023 · S/N 1218N444TCHalstead Land & Cattle Inc · Arnold, NEBuilt 1975 · S/N D-9783N444THAtlas Aviation Tampa Inc · Tampa, FLBuilt 2020 · S/N 172S12440N444TJWerner Michael H · Edmond, OKBuilt 1979 · S/N 17272953N444TMAviation Performance Solutions LLC · Mesa, AZBuilt 2002 · S/N 155N444UHAlba Aviation Services Inc · Scottsdale, AZBuilt 2003 · S/N 10055N444UJAmbush Aviation LLC · Anabel, MOBuilt 2005 · S/N 1348N444VBYoung Reginald S · Buffalo Junction, VABuilt 2001 · S/N 18281034N444VCGa Flying LLC · Jupiter, FLBuilt 1999 · S/N 18280483
Back to AD 2007-04-19 R1