AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N15597Watson Keith A · Sale Creek, TNFirst renewal noticeN1559RMoore Kira G · Newcastle, CAN155AEBissat Rashid H · Visalia, CAN155ARPiper Aircraft Inc · Vero Beach, FLN155BHRyan John P · Kankakee, ILN155BKCarroll Brian D · Marion, MTN155CDVillines Dustin · Lincoln, ARN155CPEmerald City Aircraft Leasing Inc · Port Orchard, WAN155CTOutsideloop LLC · Denver, CON155EFlieger LLC · Falls Church, VAN155EPGogoplex LLC · Wilmington, DEN155JGDesch Edward J III · Aldie, VAN155JHCrew Support LLC · Draper, UTN155JKDa Fuq Dat Beepin Be LLC · Saint Petersburg, FLN155SHSpitzer Helicopter LLC · Woodland Hills, CAN155WWJohnson Otis L · Seminole, TXN15600Curry Dwain · Apopka, FLN15601Wisconsin Fox River Flyers · Milwaukee, WIN1560RAbria Consulting LLC · New Milford, NJN15610Stull Christopher H · Berrien Springs, MIN15612Bonnette William A · Gill, MAN15616Jpd Aviation LLC · Newton, NJN1561RKimmerer William J · Berkeley, CAN15621Skyline Aviation Inc · Wilmington, DEN15623Terrill Wallace · Otis, MAN15624Ultimax Inc · Columbus, OHN1562RArnesen Thomas · Sioux Falls, SDN1562XLaliberte Christopher M · Ridgecrest, CAN15630Nutile Joe R · Paso Robles, CAN15631Arnold Aviation LLC · Camden, TNN15633Jime Aero LLC · Ontario, CAN15640Foster Anthony · Beavercreek, ORN15642Lukes Aviation LLC · West Richland, WAN15643Aerolease Ltd · Dubuque, IAN15644Meriden Aviation Center LLC · Meriden, CTN15645Ripken Robert L · Stockton, CAN15646Smith Michael S · Norman, OKN15647Flynn Daniel C · Malvern, PAN15650Shank Paul W · Blairsville, PAN15652Raider Aviation LLC · Lubbock, TXN15655French Creek Holdings LLC · Saratoga, WYN15663Jmn Aircraft LLC · Ashland, MAN15664Bergantino Julio L Jr · Tucson, AZN15665Burns Dana W · Pataskala, OHN15666Miller Michelle · Las Vegas, NVN15677Magneto Flyers LLC · Alexandria, OHN15678Pg Farms Inc · Shelton, NEN15684Carr Sean Michael-Noel · Prescott, AZN1568RRobinson Leonard C · Boca Raton, FLN1568WDfb Holdings LLC · Coeur D Alene, ID
Back to AD 2006-10-21