AD 2007-04-19 R1
Registered aircraft · 108,434
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
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.
N270CPCivil Air Patrol · Maxwell Afb, ALN270DASaunders Matthew K · Palm Coast, FLN270DMMarbry Holdings LLC · Naples, FLN270FASchoettelkotte Christopher B · Friendswood, TXN270GGSkylens LLC · Hammond, LAN270JARegistered aircraftN270KFirst Gear Inc · Fort Wayne, INN270KCLeyva Kevin S · Wilbur, WAN270MDGlass Worxz LLC · Gilbert, AZN270MHOgier Charles E Jr · Las Vegas, NVN270MRFurtado William J III DBA · Fremont, CAN270RBaxter Thomas L · Stockbridge, GAN270RCEagle 1-N270rc LLC · San Juan, PRN270SASundance Airport Fbo LLC · Yukon, OKN270SMAims Community College · Greeley, CON270SUPiper Aircraft Inc · Vero Beach, FLN270UOhio University · Albany, OHN270WMsc Services Inc · Hugo, OKN270WCState Of Alaska Dept Of Fish And Game · Palmer, AKN270ZMcgee Andy R · Town Creek, ALN2710JPeople Incorporated Of Virginia · Abingdon, VAN2710SMarshall Loraine · Cincinnati, OHN2710XReinhart Richard A · Cook, MNN2710YPink Ibis Air LLC · Vero Beach, FLN27117Chalfant William Paxson III · Concord, NCN2711GAlexander Marshall J · Klamath Falls, ORN2711NMountain Air Aviation LLC · Fruit Heights, UTN2711PPadrta Dustin Alexander · Sterling, AKN2711RBoeing Employees Flying Association Inc · Renton, WAN2711TLucero Nicholas T · North Hollywood, CAN2711WAerotec LLC · Denver, NCN2711ZSchmelzer Thomas D · Lino Lakes, MNN2712FDodson International Parts Inc · Rantoul, KSN2712GGrady'S Auction & Realty Inc · Newport, ARN2712MCardinal Adventures LLC · Green Bay, WIN2712QGrotbeck Carter L · Albuquerque, NMN2712RSimply Living LLC · Fort Myers, FLN2712TJames Todd E · Lebanon, PAN2712WFadio David C · Elmira, NYN2712YCarranza Jorge Oros · Dallas, TXN2713GPalmer Carroll W · Harper, ORN2713MBeacon West LLC · Billings, MTN2713QJeff Jones Aircraft Company LLC · Quincy, WAN2713WDutro Tammy S · Dublin, OHN27148Numerick Allen P · Washington, MIN2714CLipcon James P · Stow, MAN2714FDdh LLC · Goddard, KSN2714GRegistered aircraftN2714PGeller Glen C · Beaverton, ORN2714TVertical Flight Leasing LLC · Wilmington, DE
Back to AD 2007-04-19 R1