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.

N703LTAt Aero LLC · Wilmington, DEBuilt 1980 · S/N BB753 N703MDavis Aviation Inc DBA · Brandon, MSBuilt 1977 · S/N BB-271 N70CULou Dell Aviation LLC · Simpsonville, SCBuilt 1981 · S/N BB-888 N70JJWilmington Trust Co Trustee · Wilmington, DEBuilt 1988 · S/N BL-130 N70MNState Of Minnesota · Saint Paul, MNBuilt 1993 · S/N BB-1447 N71Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-6 N710JBSunset Leasing Inc · Sarasota, FLBuilt 2001 · S/N BB-1784 N710NCNorth Country Aviation Inc · Gaylord, MIBuilt 1977 · S/N BB-322 N711VVMaynard Aviation LLC · Westfield, MABuilt 1990 · S/N BB-1365 N712RHBtr Air Charter-Ka LLC · Baton Rouge, LAS/N BB-1839 N713RHFalcon Air LLC · Olive Branch, MSBuilt 1987 · S/N BB-1274 N715RDHalls Aviation LLC · Charleston, SCBuilt 1980 · S/N BB-707 N716APButler Aviation Inc · Houma, LABuilt 1978 · S/N BB-448 N716AVMas Trailers LLC · Dalhart, TXS/N BB-1876 N716TAB P Air LLC · Delhi, LAFirst renewal noticeBuilt 1995 · S/N BB-1509 N717DCAircraft Unlimited Inc · Pierre, SDS/N BB-1261 N717VAAtlanta Air Charter Inc · Kennesaw, GABuilt 2007 · S/N BB-1994 N719BHWilliams Farms LLC · Panhandle, TXBuilt 1979 · S/N BB-564 N71VTWestern Wings Corp · Roseburg, ORBuilt 1980 · S/N BB-709 N72Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-7 N7202YBoeing Co · Berkeley, MOBuilt 1984 · S/N FA-12 N720AMKing Eagle II LLC · Grand Blanc, MIBuilt 1999 · S/N BB-1663 N721EAAcellerated Interventional Orthopedics Pllc · Lawton, OKBuilt 1980 · S/N BB-679 N721RDKing Edward Inc · Cullman, ALBuilt 1980 · S/N BB677 N722BRB&L Aviation LLC · North Myrtle Beach, SCBuilt 2000 · S/N BB-1701 N722TRJamair LLC · Poland, OHBuilt 1981 · S/N BB-938 N724AAAlbright Insurance Holdings Inc · Burlington, NCBuilt 1998 · S/N BB-1632 N7250TEpic Aviation Inc · New Smyrna Beach, FLBuilt 1985 · S/N BB-1237 N725RABar Environmental Supply Inc · Brentwood, TNBuilt 1980 · S/N BB-725 N727BCue Capital LLC · Edmond, OKBuilt 2000 · S/N BB-1734 N727BWAcc4m LLC · Augusta, GABuilt 1981 · S/N BB-861 N729AKDavis Aviation Inc DBA · Brandon, MSBuilt 1988 · S/N FA106 N72HTSan LLC · Knoxville, TNBuilt 1984 · S/N BB-1153 N73Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-8 N730HMIsr Aviation LLC · Wilmington, DEBuilt 1999 · S/N BB-1648 N744PCCorzon Aircraft Sales LLC · Highland Park, ILBuilt 2003 · S/N BB-1815 N745EALaurel Road Properties LLC · Morehead City, NCBuilt 2001 · S/N BB-1745 N746KFTriple Fes LLC · San Antonio, TXBuilt 1979 · S/N BB-473 N748LBAnfinson Aviation Inc · Williston, NDBuilt 1990 · S/N BB-1374 N74AWMonroe County Sheriff'S Office · Key West, FLS/N BB-1233 N74RARoyal Air Freight Inc · Waterford, MIBuilt 2004 · S/N BB-1869 N75Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-10 N750BBJjs3 LLC · Baton Rouge, LABuilt 1983 · S/N BB-1169 N750KAN750ka LLC · Wilmington, DEBuilt 1977 · S/N BB224 N750TTDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N BB215 N754CACarver Aero LLC · Davenport, IABuilt 2009 · S/N BB-2013 N757GWGreenway Air LLC · Wilmington, DES/N BB757 N757RK757 Romeo-Kilo Aviation LLC · Corpus Christi, TXFirst renewal noticeBuilt 1987 · S/N BB1278 N7586ZGould Aviation LLC · Aberdeen, SDBuilt 1985 · S/N FA71 N75LVCook Childrens Health Enterprises · Fort Worth, TXS/N BB-1075

Back to AD 89-19-04 R1