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.
N287JTA W Aviation · Sevierville, TNN287KMO'Connor Thomas F · Plano, TXN287LUS Department Of The Interior · Boise, IDN287LHJft Re Development LLC · Bentonville, ARN287LMDjc Bonanza LLC · Stuart, FLN287MCValiair Lc Trustee · Casper, WYN287MSKelly Francis · El Paso, TXN287PN8297n LLC · Evansville, INN287PASkywest Leasing Inc · St George, UTN287PJWaterbury Craig A · El Paso, TXN287PSSides Michael E · Bartley, NEN287TCAiv Con Inc · Charlevoix, MIN287VCGreat Sky LLC · Brooklyn, NYN28800El Tigre Aviation LLC · Brookfield, WIN28803Candeletti James J · Forked River, NJN28806Creisler Vincent L · Kent, WAN28807Haight Donald E · Trumbull, CTN28808Aba Aviation LLC · Buford, GAN28809Cox Terry J Trustee · Missouri City, TXN2880EDemulling Michael C · New Richmond, WIN2880PSaalsaa Brad · Ketchikan, AKN2880RPhelps Thomas J · Orem, UTN2880TVuppala Kavya · Springtown, TXN2880XGerstung Dennis R · Anchorage, AKN2880YRegistered aircraftN28810Air & Road Sports Inc · Las Vegas, NVN28811B D Aviation LLC · Sauget, ILN28815Registered aircraftN28819Sun Samuel K · San Diego, CAN2881FAirplanes Over Niagara LLC · Lewiston, NYN2881GGardocki Joseph E · Oklahoma City, OKN2881PChicago Glider Club · Minooka, ILN2881QNeenah Aircraft Leasing LLC · Neenah, WIN2881ZHoag Peter J · Arlington Heights, ILN28820Elite Flying Group LLC · Northampton, MAN2882CG & M Aircraft Inc · Wheat Ridge, CON2882RPostlewait Logging Co · Port Allegany, PAN2882TParis Air Inc · Vero Beach, FLN2882WWholey James · Saratoga, CAN2882YVx Aviation LLC · Palisade, CON28831Stewart William G · Thousand Oaks, CAN28834Vogel Victor H Trustee · Loveland, OHN28838Giuffre Matthew S · The Villages, FLN28839Turgeon Douglas · Anderson, SCN2883RCallegari Sergio P · Reno, NVN2883TGolembiewski William · Hookstown, PAN2883XRamano Raymond C · Napa, CAN2883ZFoster Gary E · Kress, TXN28842Turnquest Joad · Sanford, NCN28847Mayeda Ronald K · Foster City, CA
Back to AD 2007-04-19 R1