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.
N20711Atpce LLC · Wilmington, DEN2071BTrulson Gary S · Edgerton, WIN2071LDelong Scott R · Punta Gorda, FLN2071RHughes Audie D · Starkville, MSN20727Atpce LLC · Wilmington, DEN2072SKelty Joel P · Portland, ORN2072TAshby Darrell · Elko, MNN2073TMcguire Guy D · Stevensville, MDN2073XAnania Nickolas F · West Ossipee, NHN20747Above And Beyond Aviation LLC · Austin, TXN20748Registration Pending · Bethesda, MDRegistration pendingN2074CJprg Aviation Inc · Orlando, FLN20754Sweet Scott A · Naples, FLN2075AJacobs Nathan G · North Swanzey, NHN2075EStateline Aviation Inc · Dover, DEN2075LThompson Talley · Burgaw, NCN2075RBuchart Cole Scott · Columbus, OHN2075XMehling Michael · Parish, NYN2076AThomas George P Jr · Woodstock, VTN2076JEss Trent E · Loretto, MNN2076TKaplan Ross H · Pompano Beach, FLN20773Smtm Holdings Inc · Wilmington, DEN2077AN2077a LLC · Lewes, DEN2077CBudarf James Philip · Graham, TXN2077NLilylands Aviation LLC · Redvale, CON2077TThoendel Joshua R · O' Neill, NEFirst renewal noticeN20784Dbab LLC · Belleville, ILN20787Crawford Donald Mark · Frisco, TXN2078ARyan John T · Salina, KSN2078BD & P Jones Enterprises Inc · Santa Cruz, CAN2078TMavity Michael D · Phoenix, AZN2079NSkywarrior Flight Training Inc · Pensacola, FLN2079RBrian K Vittorini · Bridgeton, NJN2079TCraig James A · Salt Lake City, UTN2079WCoast Flight Training And Management Inc · San Diego, CAN2079XDe Flyers LLC · Vicksburg, MIN207AMHilger Michael D · Inver Grove, MNN207CACivil Air Patrol · Maxwell Afb, ALN207CBCalifornia Baptist University · Riverside, CAN207CWWalls Craig C · Willow, AKN207DKKufalk Darrell · Dousman, WIN207ERIndiana Helicopters LLC · Fort Wayne, INN207ESPiper Aircraft Inc · Vero Beach, FLN207GAGreer Robert H · Hudson, NHN207JJN207jj LLC · Mesa, AZN207JTTozer John E · Orono, MEN207LHSnaproll Inc · Wilmington, DEN207LSNightbreak Aviation LLC · Houston, TXN207MAStreamline Aviation LLC · Battlefield, MON207MDGv Air Inc · Medford, OR
Back to AD 2006-10-21