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.

N301CWSky 005 LLC · Colorado Springs, COBuilt 1985 · S/N FA-53 N301WYOrion Air Holdings LLC · Cheyenne, WYS/N BB-476 N302CGKiowa Turbine LLC · Galesburg, ILS/N BB-1112 N302PSF90x LLC · Modesto, CABuilt 1990 · S/N FA-213 N303CJLand Of Indiana Inc · Bedford, INBuilt 1979 · S/N BB-596 N304JSRegistration Pending · Pharr, TXRegistration pendingBuilt 1988 · S/N FA142 N304SHJaimlubec LLC · Austin, TXBuilt 1986 · S/N FA-89 N3051KBuilding Corp LLC · Huntsville, TXBuilt 1994 · S/N BB-1495 N305ELRoper Aviation LLC · Wilmington, DEBuilt 1981 · S/N BB947 N305LGEaglemed LLC · Wichita, KSBuilt 2001 · S/N BB-1789 N305SAIndigo Blue Aviation LLC · Spartanburg, SCBuilt 1986 · S/N FA-111 N307DMBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N BB-332 N30FEBpnr LLC · Lubbock, TXBuilt 1988 · S/N FA-148 N30HVCustom Fabricating & Repair Inc · Marshfield, WIBuilt 1989 · S/N FA-173 N30SETradewinds 12/21 Inc · Denison, TXBuilt 1977 · S/N BB313 N310TXRiddles Group Inc · Rapid City, SDBuilt 1988 · S/N FA-140 N312DEBest Aircraft Deals LLC · Salt Lake City, UTS/N FA-49 N313CTAlmar Aviation LLC · Greenville, KYBuilt 1979 · S/N BB-461 N313SAMccarty David M · Baker City, ORBuilt 1984 · S/N FA-5 N316GCMarc Aircraft Holding LLC · Soldotna, AKBuilt 1978 · S/N BB-430 N316RSTriple Rainbow LLC · Princeton, INBuilt 1987 · S/N FA 139 N318CBBrown Flight Properties LLC · Midland, TXBuilt 2000 · S/N BB-1730 N31FMKing Air Adventure LLC · Wilmington, DEBuilt 1981 · S/N BB-869 N31WCPro Serve Aviation LLC · Englewood, COBuilt 1979 · S/N BB-465 N323PXFehrs Aviation LLC · Seminole, TXBuilt 2002 · S/N BB-1803 N3250VK & J Air Services Ltd · Midland, TXBuilt 1995 · S/N BB-1523 N326AJVanderloop Equipment Inc · Brillion, WIBuilt 1978 · S/N BB-396 N326KWBering Air Inc · Nome, AKBuilt 1990 · S/N BB1360 N326RTPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 1979 · S/N BB553 N327LCNeptune Agricultural Group Inc · Vero Beach, FLS/N BB1427 N327MEReach Co LLC · Hughson, CABuilt 1987 · S/N FA-127 N327RBAerial Applicators Of Missouri LLC · Pollard, ARBuilt 1978 · S/N BB-335 N328CRDmg Aero LLC · Hickory, NCBuilt 1979 · S/N BB-548 N32LJCrocker LLC · Missoula, MTBuilt 1981 · S/N BB-993 N32SVDoorless Leasing LLC · Lewes, DEBuilt 1981 · S/N BB-865 N32TPIal Corp · Lewes, DEBuilt 1979 · S/N BB-456 N332CAPhysicians Air Transport LLC · Hot Springs, ARBuilt 1981 · S/N BB-816 N332JSSouth Coast Lumber LLC · Brookings, ORBuilt 2006 · S/N BB-1938 N333QTQ Flight LLC · Bernardsville, NJBuilt 2000 · S/N BB-1702 N335TAN335ta LLC · Anchorage, AKBuilt 1979 · S/N BB-514 N33KCCarvair LLC · Salem, ORBuilt 1984 · S/N FA-35 N341WBAndrews Worldwide LLC · Amarillo, TXBuilt 2005 · S/N BB-1885 N346BALwcr Transportation Inc · Minot, NDBuilt 1999 · S/N BB-1653 N349ARAcademy Resources LLC · Taos, NMBuilt 2002 · S/N BL-144 N34LTPaper Boys LLC · Dover, DEBuilt 1992 · S/N BB-1437 N351KBKabco Aviation LLC · Boaz, ALBuilt 2002 · S/N BB-1904 N351SAGuardian Flight LLC · Lewisville, TXBuilt 1992 · S/N BB1423 N356ERStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 1985 · S/N FA-55 N360EASai Flight Services Inc · Greer, SCS/N BB-1231 N360XNavecord Institute · Wilmington, DES/N BB-1783

Back to AD 89-19-04 R1