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.
N201GESanders Michael W · Austell, GAN201GHPayne Jason C · Thomaston, CTN201GJAllmarc LLC · Molalla, ORN201GNThomas J Smith · Baton Rouge, LAN201GPSale Reported · Sheridan, WYSale reportedN201GQHolm Chris C · Myrtle Point, ORFirst renewal noticeN201GRBischoff Roy H III · Belleville, ILN201GTHave Blue Aviation LLC · Philipsburg, MTN201GYBrill Daniel C · Stratford, CTN201GZNelson Jordy D · Marysville, KSN201HAAlken Glass Unlimited LLC · Devils Lake, NDN201HBCollier Ernie · Winter Haven, FLN201HCFink Katherin · Scottsdale, AZN201HGWright D Anthony · Davisburg, MIN201HJRegistered aircraftN201HMFlood Donald J · Pembroke Pines, FLN201HPCapital Auto Sales · Hickman, NEN201HQBugruggles Ltd · Wilmette, ILN201HSEuroaviation Inc Trustee · KematenN201HTHaupricht Andy C · Sanford, NCN201HUKorkow Land And Livestock LLC · Volborg, MTN201HVSnyder Dennis J · Wauwatosa, WIN201HWRichards Troy L · Saint Jo, TXN201HYMartin-Merrill Elijah · Littleton, MAN201HZBeech Aero LLC · Boynton Beach, FLN201JBParker James E Jr · Milton, FLN201JCSpernak Bernard L · Dover, FLN201JESimonieg Keith J · Dickinson, NDN201JGBerggren Ryan J · Newton, NJN201JJD & M Aviation LLC · Ozark, MON201JLMorin Roch L · Washington, MIN201JMHitchcock Robert C II Co Trustee · Chula Vista, CAN201JREverett Holdings LLC · Cedar Rapids, IAN201JSConte Anthony J · Haskell, NJN201JUWalsh Matthew R · Gainesville, GAN201JVBremer Michael D · Anderson, SCN201JWAuer Regis · St Petersburg, FLN201JXPrendergast Gerald T · Lakewood, CAN201JZGill Kevin W · Massillon, OHN201KBKyle Graham G III · Argyle, TXN201KCPresley Ralph Lee · Cornelius, NCN201KDBarber Ted · Huntington, NYN201KEEvory Karl L · Indianapolis, INN201KFGaddis Frederick R · Fairmount, INN201KGWaddell George A · Marietta, MSN201KHPurpura Dominic L · Batavia, ILN201KKHill Barry A · Plano, TXN201KLSwanson Noah · Woodbury, MNN201KQIvey John S Jr · Whitmore Lake, MIN201KRWesterlin Eleanor J · Yorba Linda, CA
Back to AD 2006-10-21