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.
N129HFHeritage Asset Leasing LLC · Ronkonkoma, NYN129JPSlezak Douglas C · Atascadero, CAN129JZThomas James E · Forsyth, GAN129KFf22 LLC · Scottsdale, AZN129MAAttwood Nicholas John · Ashburn, VAN129MBYellowfin Air Services LLC · Wilmington, DEN129MTMiddle Tennessee State University · Murfreesboro, TNN129RCAirris Aviation & Marine Co · N Fort Myers, FLN129SEBarrington Air Inc · Littleton, CON129SJWorking Capital Group LLC · Rogers, ARN129SWRoyal Air LLC · Sarasota, FLN129TFGary Boyce Aircrft Sales LLC · Shelbyville, TNN129WMSky Solutions LLC · Detroit, MIN129WSNew Horizon Aviation Inc · Warwick, RIN129XCCatbird Cub LLC · Tampa, FLN129YEBuell Travis W · Harper, TXN12ACCarroll Alan R · Mc Farland, WIN12ADAltizer John N · The Woodlands, TXN12AKBurk Ross T · Casper, WYN12ALFuller Deidra K · Great Falls, MTN12BEElliott Russell R · Wasilla, AKN12BHMunk-Ee Business Aviation LLC · Linden, MIN12CKAmoss Harold Lindsay III · Redmond, ORN12DDSpencer William D · Martinsville, VAN12EEArizona Cloudbusters Inc · Mesa, AZN12FPElliott James R · Denton, TXN12GANy Flying Tigers LLC · Ronkonkoma, NYN12GEJ&P Master Flooring Corp · Lauderdale Lakes, FLN12GNNauta Gordon Wayne · Palmdale, CAN12GRJones Richard B · Georgetown, TXN12HDMorotti John · Polson, MTN12HFParagon Airplane Leasing Co · Fort Myers, FLN12HHWilliams Jeffrey · Florence, ALN12HPState Of Ohio · Columbus, OHN12HUVintage Flyers LLC · The Villages, FLN12HYRegistration Pending · Nephi, UTRegistration pendingN12JLGiber Kristofor D · Manvel, TXN12JXAc Holdings II Inc · Lewes, DEN12KDDeeble Kenneth M · Dayton, MTN12KWAllied Moulded Products Inc · Bryan, OHN12LMHaney Andrew J · Mt Morris, PAN12LPBlewett John Thomas Jr · Springfield, GAN12LVR2b2 Enterprises Lllp · Weldon Spring, MON12MBHarrison Hayden F · Mckean, PAN12MVKarduck Craig · Morgan, UTN12NMPlane Fun Inc Tr Trustee · Snellville, GAN12PKDuncan Aviation Inc · Lincoln, NEN12PUMeyer Daniel B · Redding, CAN12PXMvs Air LLC · Kalispell, MTN12QRWilson Koby D · Southside, AR
Back to AD 2006-10-21