Registered aircraft · 897

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:89-19-04-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:89-19-04-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:89-19-04-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:89-19-04-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:89-19-04-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:89-19-04-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.

N572WCRegistration Pending · Bullard, TXRegistration pendingBuilt 1981 · S/N BB933 N576CLAci Aviation LLC · Victor, MTBuilt 1979 · S/N BB-576 N57BDynamic Avlease Inc · Bridgewater, VABuilt 1983 · S/N BL-67 N57FTS & H Holdings LLC · Wichita, KSS/N BB-136 N57GAKa73 LLC · Little Rock, ARBuilt 1979 · S/N BB-477 N57PASpieker Warren E Jr · Menlo Park, CABuilt 1992 · S/N BB-1444 N580BAN Flight LLC · Kenedy, TXBuilt 2007 · S/N BB1975 N580BKJohn Newcomb Enterprises Inc · Blacksburg, VABuilt 1982 · S/N BB-1000 N581EAElite Medical Air Transport LLC DBA · El Paso, TXBuilt 2002 · S/N BL-143 N585CEAugusta Aviation Inc · Hilton Head Island, SCS/N BB1194 N585RBPonderosa Aviation LLC · Safford, AZBuilt 1979 · S/N BB-528 N586UCMegel Air LLC · Cleveland, GABuilt 1983 · S/N BB-1118 N587TWAircraft Security Corp · Laredo, TXBuilt 1979 · S/N BB-587 N58AYAviapa Flight LLC · Doylestown, PABuilt 1995 · S/N BB-1511 N58QDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeS/N BL8 N593GGCircle S Air LLC · Wilmington, DEBuilt 1980 · S/N BB-593 N597BAMca-Plane LLC · Grand Blanc, MIBuilt 2004 · S/N BB1851 N597MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N BB-720 N59MDynamic Avlease Inc · Bridgewater, VAS/N BB-1419 N5AETenax Aerospace LLC · Ridgeland, MSS/N BB-1891 N5PXRed Poodles LLC · Boston, MABuilt 1979 · S/N BB-554 N5STDe Paz Aviation LLC · Coral Gables, FLBuilt 1977 · S/N BB-289 N600RKLc Whitford Co Inc · Wellsville, NYBuilt 2002 · S/N BB-1800 N601CWFree Bird Aviation LLC · Ridgeland, MSBuilt 1981 · S/N BB-842 N605JDM2driver LLC · Midland, TXBuilt 1996 · S/N BB-1555 N6069AAt Aero LLC · Wilmington, DEBuilt 1978 · S/N BB-357 N607FJGuardian Flight LLC · Lewisville, TXBuilt 2006 · S/N BB-1963 N60RADodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N BT-7 N610TANorth Flight Aero Med · Traverse City, MIBuilt 1998 · S/N BB-1609 N611SDGreen Diamond One LLC · Knoxville, TNBuilt 1988 · S/N BB-1307 N613GAGaf Holdings Inc · Visalia, CABuilt 2005 · S/N BB-1909 N613TAWild Blue Aviation LLC · Wilmington, DEBuilt 1997 · S/N BB-1581 N616RPCapling Aviation LLC · Labelle, FLBuilt 1989 · S/N FA-181 N618United States Department Of Interior · Boise, IDBuilt 1990 · S/N BB-1378 N6182AA&R Air Inc · Hinsdale, ILBuilt 1994 · S/N BB-1484 N619PAPafford Air Of Mississippi LLC · Ruston, LABuilt 1993 · S/N BB-1458 N61APTrewhitt Jamie Mcmahan · Pacific Palisades, CAS/N BB-1192 N61AYAonvo Investment LLC · North Miami, FLS/N BB575 N61DNDn2 Aviation LLC · Fernandina Beach, FLBuilt 1992 · S/N BB-1438 N61PCN61pc Leasing LLC · Ponca City, OKBuilt 1994 · S/N BB-1483 N61PEHc4 LLC · Fair Play, SCBuilt 1983 · S/N BB-1132 N61THBlue Heron Aviation LLC · Orwigsburg, PABuilt 1984 · S/N FA-17 N621AFBright Skies Mt LLC · Kalispell, MTBuilt 1978 · S/N BB-331 N621JGWhite Aviation LLC · Ashford, ALBuilt 1981 · S/N BB-834 N622KMK & M Equipment Co LLC · Chatsworth, CABuilt 1981 · S/N BB-491 N625BWTechnology Service Corp · Arlington, VABuilt 1982 · S/N BB1090 N627MGMile High Adventures LLC · Yazoo City, MSBuilt 1989 · S/N FA-197 N629RPBasche Properties II LLC · Cleveland, OHBuilt 2007 · S/N BB-1984 N6300FTenax Aerospace LLC · Ridgeland, MSS/N BB-1865 N63593Rbr Development LLC · West Plains, MOBuilt 1979 · S/N BB552

Back to AD 89-19-04 R1