Registered aircraft · 1,310

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:2007-26-11') 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-26-11') 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:2007-26-11')
    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-26-11')
  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:2007-26-11')
  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-26-11')
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.

N1007GDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9164 N100AXApplied Underwriters Inc · Omaha, NEBuilt 1995 · S/N 155 N100UPFj100 LLC · Waco, TXBuilt 1988 · S/N 44 N100UUQualitair LLC Trustee · MichelstadtS/N 1000 N101WFBl Custom Equipment LLC · Cincinnati, OHBuilt 2003 · S/N 197 N1020GHelifun Expeditions LLC · Kalispell, MTBuilt 2016 · S/N 8250 N102AJBird Dog Aircraft LLC · Billings, MTS/N 7868 N104LNPathfinder Leasing LLC · Anchorage, AKBuilt 2006 · S/N 4094 N105BKJetcom LLC · Lemon Grove, CABuilt 1989 · S/N 070 N107GLLeep Enterprises LLC · Mishawaka, INBuilt 2002 · S/N 199 N108BKKent Aviation LLC · Midland, TXBuilt 2001 · S/N 305 N108FJBuffalo Valley Ventures Of Tn LLC · Cookeville, TNBuilt 1991 · S/N 108 N108LNAir Methods LLC · Greenwood Village, COS/N 3959 N108MAGrizzly Air Service Inc · Paris, TXS/N 792 N108PHYoung Family Aviation LLC · Sugar Grove, ILBuilt 1990 · S/N 87 N108TABristow LLC · Lake Charles, LABuilt 1998 · S/N 3080 N109LNAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3995 N109TALima Whiskey Alpha LLC · Missoula, MTBuilt 1998 · S/N 3103 N10XBmd Leasing LLC · Portland, ORBuilt 2001 · S/N 190 N111FJJfm Air LLC · Wilton Manors, FLBuilt 1993 · S/N 128 N111LNC Lou Leasing LLC · Mankato, MNBuilt 1984 · S/N 1602 N113JPJuliette Papa Leasing LLC · Kalispell, MTBuilt 1989 · S/N 2265 N113PHCherokee Helicopter Service LLC · Ford City, PABuilt 1980 · S/N 1298 N114MXAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1984 · S/N 1747 N114NSNs Air Leasing LLC · Wilmington, DES/N 7866 N115AHSky High Leasing LLC · Montrose, COBuilt 2023 · S/N 9390 N115DRTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTBuilt 2025 · S/N 9724 N115GRReach Air Medical Services LLC · Lewisville, TXBuilt 2025 · S/N 9820 N116RWCerovest Capital LLC · Lawrenceville, GABuilt 1988 · S/N 058 N117HDUS Helicopters Inc · Marshville, NCS/N 3318 N117TVU S Helicopters Inc · Marshville, NCBuilt 2012 · S/N 7464 N118LNAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4214 N118MBMountain Air Helicopters Inc · Dover, DEBuilt 2002 · S/N 3535 N118NSAirbus Helicopters Inc · Grand Prairie, TXS/N 9964 N119TVU S Helicopters Inc · Marshville, NCBuilt 1988 · S/N 2122 N120AMAir Methods LLC · Greenwood Village, COBuilt 2024 · S/N 9596 N120PDCity Of Albuquerque · Albuquerque, NMBuilt 2024 · S/N 9503 N120UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0805 N1210NTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N 105 N121RGLone Star Land & Cattle Co · Livingston, MTBuilt 2018 · S/N 8517 N121UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0806 N1228HAirbus Helicopters Inc · Grand Prairie, TXS/N 9951 N122AVase Corp V · Doral, FLBuilt 1990 · S/N 88 N122AHNorton Basin Services · Nome, AKBuilt 2023 · S/N 9509 N122UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0807 N1231ATiny Bubbles Aviation Inc · Pacoima, CABuilt 2003 · S/N 3682 N124LNAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4130 N124TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4405 N124UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0808 N125APAustin Police Dept · Pflugerville, TXBuilt 2022 · S/N 9282

Back to AD 2007-26-11