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.
N305MDPiper Aircraft Inc · Vero Beach, FLN305MMSegal Marshall B · Chicago, ILN305MRRoberts Bruce D · New London, PAFirst renewal noticeN305MVGreatest Generation Naval Museum · Colorado Springs, CON305NDUniversity Of North Dakota · Grand Forks, NDN305NKKamasano LLC · Highland, CAN305PFSale Reported · Crystal, MNSale reportedN305PJBradley Alana J · Joliet, ILN305PTCappe Investment Group LLC · Homestead, FLN305RCWashington State Patrol · Olympia, WAN305RHGreater Boston Soaring Club Inc · Sterling, MAN305RSElite Approach LLC · Chesterfield, MON305SLSealand Airways Miami LLC · Miami, FLN305SNMeshoppen Air LLC · Tunkhannock, PAN305SU305su LLC · Rexburg, IDN305TCjn Enterprises LLC · Elbert, CON305TAPlanes Of Fame Air Museum · Chino, CAN305TXCareer Track 2 LLC · Wilmington, DEN305UMParagon Airplane Leasing Co · Fort Myers, FLN305WBCardinal Aviation LLC · Charles City, VAN305WRKnudsvig Travis · Waterloo, IAN305WWObrien Aviation Inc · Port Orange, FLN305XXDs Group LLC · Miami, FLN305ZReid William R Jr · Clarksburg, WVN30602Reinert Joseph M · Ringgold, GAN30603Registered aircraftN30608Christiansen Aviation LLC · Wilmington, DEN3060BPrestige Worldwide Aviation LLC · Downers Grove, ILN3060FEl Paso Aero Inc · El Paso, TXN3060LLang Scott T · Waseca, MNN3060QYarg Tap LLC · Midland, TXN3060RArrow N3060r LLC · Sheridan, WYN3060WRegistration Pending · Ojai, CARegistration pendingN3060YB&D Flight Club LLC · Portage, INN30612Wheeler Vincent · Harwinton, CTN30615Yanichko Robert · Weeki Wachee, FLN30617Executive Flight Training & Services LLC · Sanford, NCN3061CTharp Aerospace LLC · Charleston, SCN3061DJeppson Edward Mckay Trustee · South Jordan, UTN3061ERim Rock Ranch LLC · Dover, DEN3061FTaber Deane W · Weirsdale, FLN3061RCohns Willie · Elizabethtown, KYN3061WCcn Air LLC · Bloomington, INN3061YHott Steven A · Kokomo, INN3061ZKell Thomas G · Anchorage, AKN30622Money Aerial Media LLC · San Diego, CAN30626Hoese Ray D · San Antonio, TXN3062FJohnson Sean D Trustee · Fresno, CAN3062LMerino Rodrigo R · Chilton, WIN3062RBuddys Aviation LLC · East Bernstadt, KY
Back to AD 2007-04-19 R1