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.
N248KCracker Aviation LLC · Jupiter, FLN248MGGeorgia Aviation Authority · Eastman, GAN248RCMckinley I Blake Jr · Spokane Valley, WAFirst renewal noticeN248RRWalter Air Co LLC · Oakdale, CAN248SFEl Prop Plane I LLC · Metairie, LAN248SWHicks James P · Franklin, OHN248TFVisionary Holdings LLC · Missoula, MTN2490MDmld Corp · Wilmington, DEN2490YSheboygan Flight Plane III LLC · Sheboygan, WIN2492TOmni Aviation LLC · Pickerington, OHN2494MJbbs Enterprises Inc · Middletown, DEN2495MPark Brian D · Springville, UTN2495TAvia Flight Academy LLC · Stratford, CTN2496MMorgan Jay · Fort Mill, SCN2497RMarkley John T · Center Harbor, NHN249AMShackelford John S Jr · Roanoke, TXN249CBCalifornia Baptist University · Riverside, CAN249DGRegistered aircraftN249DMAnderson Spencer D · Lafayette, LAN249ECuadra Gabriel W · Houston, TXN249FBK4m Aviation LLC · Marksville, LAN249FSAdvanced Charter & Instruction LLC · Costa Mesa, CAN249JAEagle Aviation LLC · Indianapolis, INN249JSCrystal Coast Training LLC · Kinston, NCN249KFf22 LLC · Scottsdale, AZN249MAQueen City Flying LLC · Helena, MTN249MEN249me LLC · Ottumwa, IAN249MGGeorgia Aviation Authority · Eastman, GAN249MLFlaspohler Edwin L · Ballwin, MON249PKVreeland James H · Bedford, PAFirst renewal noticeN249RFields Travis · Lees Summit, MON249RDJohnson Mark A · Argyle, WIN249RRChrest Harry David Jr · Charleston, WVN249SFCasarez David W · Carmel Valley, CAN249VWitt Frank L · Waco, TXN249WFWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN24AFAbove & Beyond Aviation LLC · Austin, TXN24ALHansen Ronald J · Yuma, AZN24APMartinelli John P · Cumberland, RIN24AZHawkins Joseph F · Twin Falls, IDN24BBSj Aviation LLC · Oxford, MIN24BJWasson Brian P · O Fallon, MON24BQAb Prop Plane II LLC · Metairie, LAN24BSSiemers Warren G · Fort Collins, CON24BXColvin Clu D · Big Cabin, OKN24BYOur Sky LLC · Woodinville, WAN24CManganaro Andrew J · Xenia, OHN24CBRuggiero Lawrence G · Greenville, SCN24CKAir Travel Management LLC · Lemont Furnace, PAN24ELDye Eric M · Winters, CA
Back to AD 2006-10-21