Registered aircraft · 108,421

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-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

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.

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

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.

N105HFHeritage Asset Leasing LLC · Ronkonkoma, NYS/N 172S8724 N105HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881996 N105JGSky Runner LLC · Starkville, MSBuilt 1999 · S/N 25159 N105JHBaxter Brandon C · Wasilla, AKBuilt 1947 · S/N 12-3240 N105JKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 17275306 N105JMBullard Roy P · Granbury, TXBuilt 2006 · S/N 18281743 N105JPPittman Discover Flight LLC · Oshkosh, WIS/N 5150 N105JRRobinson Matthew W · Duncan, OKBuilt 1981 · S/N 18-8109070 N105JWLayton Stephen D · Lovington, NMBuilt 1989 · S/N 1609 N105KAGillespie Todd · Trenton, SCS/N 401-0238 N105LRegistered aircraftBuilt 1959 · S/N 35981 N105LULynn University · Boca Raton, FLBuilt 2005 · S/N 172S9774 N105MCMathison John M · Del Norte, COBuilt 1964 · S/N 310I0162 N105MMNorth Star Aviation Inc · Mankato, MNBuilt 1998 · S/N 071 N105MRPayne Craig W · Plant City, FLBuilt 1971 · S/N 138 N105MSWard Travis E · Tucson, AZS/N 70879 N105MTRegistered aircraftBuilt 1976 · S/N 182-64338 N105MWWilson Michael D · Saint Charles, MOBuilt 2023 · S/N MW001 N105NABond Gary G · Harvest, ALBuilt 1978 · S/N AA5B-1016 N105PAPeck John A Jr · Shady Shores, TXBuilt 1997 · S/N 29-0107 N105PDN105pd LLC · Ulysses, KSBuilt 1973 · S/N 17261469 N105RJSell Shannon Carl · Hoschton, GABuilt 2014 · S/N 3225 N105RKEwing John M · Cumming, GABuilt 1979 · S/N TK-104 N105RVOurada Don A · Lexington, TXBuilt 2001 · S/N 4194 N105RZHinson Neal · Lincoln, CABuilt 2003 · S/N 24527 N105SPDepartment Of Emergency Svcs & Public Protection · Hartford, CTBuilt 1984 · S/N 18268425 N105TCMark Johnson And Sons Plumbing LLC · Ruston, LABuilt 1979 · S/N 32-7940163 N105UTobago Six Inc · Bellevue, WAS/N 591 N105VBHughes Francis A · Ltl Egg Hbr Twp, NJBuilt 1981 · S/N 18268138 N105VPSchmitt Lee A · Birmingham, ALBuilt 2002 · S/N 3FX 020 N105XSaalwaechter John J · Lebanon, INBuilt 1960 · S/N D-6436 N105XPTilleman Samuel P · Granbury, TXBuilt 2021 · S/N 105 N1060FStrausbaugh Paul L · Clifton Forge, VABuilt 1975 · S/N 18502716 N1060RCooper Don F · Great Falls, VABuilt 1996 · S/N E-3040 N1060TWindy Hill Farm LLC · Cochranville, PABuilt 1972 · S/N 28-7205104 N1060WHarvey Ara Jr · Hernando, MSBuilt 1973 · S/N TC-1539 N1061DCcr Aviation LLC · Summit, NJBuilt 1997 · S/N E-3094 N1061ENeal Foster Trucking Inc · Woodland, CABuilt 1977 · S/N 975-77 N1061FFoxtrot Flight LLC · Clarksdale, MSS/N TH-1761 N1061PRemote Properties LLC · Anchorage, AKBuilt 1983 · S/N U20606773 N1061QLbdd Enterprises 61q LLC · Pittsburgh, PABuilt 1977 · S/N 32-7200015 N1061WHollinshed Thomas O · Fayetteville, NCBuilt 1973 · S/N CE-427 N1061XMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 172-69458 N1061YSeward Mark A · Seattle, WABuilt 1969 · S/N NAV-4-2531 N10624Daytona Aircraft Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9825 N1062FSale Reported · Independence, ORSale reportedBuilt 1975 · S/N 18502718 N1062UNathan John K · Seabrook, TXS/N 32-40070 N1062WSale Reported · Douglas, GASale reportedBuilt 1973 · S/N E-411 N10632Skyblue Aviation Cr Inc · Merritt Island, FLBuilt 2007 · S/N 17281431 N1063BFlat Earth LLC · Kalispell, MTBuilt 1958 · S/N 1290

Back to AD 2007-04-19 R1