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.
N3997DBowe Timothy R · Minot, MEN3997KFly Around Alaska LLC · Palmer, AKN3997NStevens James A · Acworth, GAN3997QMurray Edward K · Fallbrook, CAN3997TBradley Edward T · Jack, ALN3997WJaroch Eric J · Houghton Lake, MIN3997ZBrown Brandon T · Dallas, TXN3998DStewart Matthew L · Camano Island, WAN3999International Air Service Inc Trustee · Carson City, NVN39994Porter Bruce R · Wichita Falls, TXN39995Kuhlman Robert W Jr · Gainesville, GAN39998Becker Kurt G · Dexter, NMN3999RPhillips Faye L · Sierra Vista, AZN3999SViking Aviation LLC · Kindred, NDN3999YSlyman David F · Inver Grove, MNN3999ZGaston James P · New York, NYN399AAAoa Kissimmee Inc · Kissimmee, FLN399AKTurney Van H · Nampa, IDN399BWilliams Jack J · Jasper, GAN399BCParadox Aviation LLC · Whiting, IAN399BPAmber Air LLC · Dallas, TXN399CAHoman Mark A · Wake Forest, NCN399CEEddings Charles A · Sheridan, ORN399CPCivil Air Patrol · Maxwell Afb, ALN399CVCivil Air Patrol · Maxwell Afb, ALN399DPThomason Charles P · Columbus, GAN399ESBray Aviation LLC · Calera, OKN399FFieldgrove Matt L · Somerton, AZN399JTGiannoulas Chris Paul · Federal Way, WAN399KOsborn Ferrell V · Avery Island, LAN399KMCustodio Olga · San Antonio, TXN399LMPepper LLC · Winter Garden, FLN399LT5280 High Corp · Wilmington, DEN399MJohnsey Stanford Wallace · Kingsville, TXN399MACavorite Aviaton LLC · West Jordan, UTN399MCRegistered aircraftN399MESound Sleep Clinic Pllc · Bainbridge Island, WAN399NBicknell Brooks E · Andover, NHN399PTDethomas John V Trustee · Boise, IDN399RBReese Rick Lee · Shelton, WAN399RCSouthwestern Development & Leasing Inc · Costa Mesa, CAN399RMEyles Edwin W Jr · Butler, PAN399RSRegistered aircraftN399SBBuchanan Sam C · Athens, ALN399TBg Flight Group LLC · Bowling Green, KYN399TABeattie Richard N Trustee · Anacortes, WAN399TCTexas State Technical College · Waco, TXN399ZFlyin Horse LLC · Columbus, GAN39ACCoyle Whitney J · Edgewater, FLN39ADRobbins William Clark · Anchorage, AK
Back to AD 2007-04-19 R1