Registered aircraft · 108,433

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.

N200PWGarris Steven L · Oceanside, CABuilt 1974 · S/N 28-7415182 N200QBluth Marshall S · Great Neck, NYBuilt 1971 · S/N CE-339 N200RBHollingsworth Robert D · Odessa, FLBuilt 1989 · S/N 001 N200RCRc Aviation LLC · Omaha, NEBuilt 1975 · S/N 21061073 N200RFRushin William J · Greenwood, INBuilt 1973 · S/N M-1457 N200RLAlpha Aviation Services LLC · Chelsea, ALBuilt 1969 · S/N 28R-35210 N200RTRiley Nolan C · Lubbock, TXS/N TK-101 N200STk Aviation LLC · Willow Street, PAS/N 609 N200SFRes Solutions Inc · Anderson, INBuilt 1978 · S/N 32R-7985034 N200SHHoward Steve · Jefferson City, MOBuilt 1979 · S/N 310R1601 N200SPN200sp LLC · Erie, COBuilt 1967 · S/N TE-487 N200SXAllen Investments Aviation & Marine Inc · Fort Myers, FLBuilt 1994 · S/N 100 N200TWeishaar Walt E · Livingston, TXBuilt 1964 · S/N 15060991 N200TBS&U Property Investments LLC · Wellington, FLBuilt 2023 · S/N 200TB N200TLHusnik Brad M · Forest Lake, MNBuilt 1966 · S/N U206-0559 N200UAUrrea Hugo Edmundo Rincon · Houston, TXBuilt 1980 · S/N 21063921 N200UGRaw Logistics LLC · Bethel, NCBuilt 1978 · S/N E-1225 N200UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2014 · S/N 4634 N200USFly More LLC · Chattanooga, TNBuilt 1976 · S/N 28-7690273 N200VPDrp Aviation LLC · Southlake, TXBuilt 2000 · S/N 29-0231 N200WAYoedhana Christian · Pflugerville, TXBuilt 1973 · S/N 28R-7335363 N200WCSigman Paul L · Incline Village, NVBuilt 1993 · S/N 792 N200WRVaughan Jason B · Sublette, KSBuilt 1978 · S/N 21062478 N200WSSierra Juliet Nm LLC · Santa Teresa, NMBuilt 1974 · S/N 34-7450117 N200WWRoark LLC · Bend, ORBuilt 1985 · S/N 46-8508035 N200YRSloan Cooper · Seattle, WAS/N 28-7615279 N200ZCTc Holdings Delaware Inc · Overland Park, KSBuilt 2020 · S/N 1187-2020 N200ZFPhillips Robert A · Saluda, NCS/N 24604 N20102Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17261010 N20106Atlanta Air Academy LLC · Kennessaw, GABuilt 1972 · S/N 17261014 N2010AMaine Instrument Flight · Augusta, MEBuilt 1978 · S/N M-2066 N2010CLegner Leasing LLC · Las Vegas, NVBuilt 1958 · S/N TD-177 N2010GFox Stephen A · Wasilla, AKBuilt 1958 · S/N 51310 N2010LTec Consulting LLC · Farmingdale, MEBuilt 1978 · S/N M-2058 N2010TGustafson Keith W · Waleska, GABuilt 1970 · S/N 10 N2010WHogsett Troy J · Willow Springs, MOBuilt 1965 · S/N CD-972 N2010XHutchinson Darrold K Trustee · Hingham, MTBuilt 1965 · S/N 18256110 N2010ZSanchez Michael G · Hesperia, CABuilt 1967 · S/N 28-22409 N20115Alpha Zulu Aviation LLC · San Diego, CABuilt 1972 · S/N 17261021 N20116Paxton Roger D · Norman, NCFirst renewal noticeS/N 17702630 N2011CTuorila Leo Eric · Anderson, SCBuilt 1958 · S/N TD-178 N2011SHeath Stephen · Alpine, TNBuilt 1975 · S/N 21060979 N2011XSalem Ricky L · Burnet, TXBuilt 1965 · S/N 18256111 N20120Bennett Robert J Jr · Minneapolis, MNBuilt 1978 · S/N M-2071 N20121Fly Maui LLC · Puunene, HIBuilt 1972 · S/N 17261025 N20123Irungu Gitau · Charlotte, NCBuilt 1972 · S/N 17261027 N20124Cerven Bohuslav Bo · Claremont, CABuilt 1977 · S/N 17702631 N20125New Horizon Aviation Inc · Warwick, RIBuilt 1978 · S/N ME-94 N20126Papa Whiskey Enterprises LLC · Merrimack, NHBuilt 2001 · S/N 18280951 N20127Lewallen David H · Alexander, ARBuilt 1977 · S/N 17702633

Back to AD 2007-04-19 R1