AD 2007-24-13
Registered aircraft · 4,026
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:2007-24-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-24-13')
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:2007-24-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-24-13') 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.
N6CDAviator One LLC · Holly Springs, NCN6MPTilt Up Air LLC · Middleboro, MAN7007VTurk James H · Mesa, AZN700FCSandlapper Aviation Of De Inc · Bennington, VTN700HGAerosphere LLC · Cedar City, UTN700PGoree John A · Iowa City, IAN701BTVgfs Aviation LLC · Naples, FLN701CDQualitair LLC Trustee · MichelstadtN701MBBoot Keith Jason · Des Moines, IAN701PMJedi Flight Training LLC · Boerne, TXN701SGMach Aviation LLC · Ocklawaha, FLN702DSYaviation LLC · Burns, TNN702FCFlight Inc · Concord, NCN702GYCirrusly LLC · Las Vegas, NVN703DRMilligan Holdings LLC · Medford, ORN703RGEfficiency LLC · Helena, MTN703TECirrus Design Corp · Knoxville, TNN704DRCactus Aviation LLC · Phoenix, AZN704GMLocke Stephen G · Charlotte, NCN704NEArian Air LLC · Cambridge, MAN704RBravo Fox Squared LLC · Lincoln, NEN705CMtm Investments LLC · Goshen, INN705CCPappa Mike Holdings LLC · Rayville, LAN705CDLearjetjohn Flying Club LLC · Moulton, ALN705SAVisser Stephen Barney · Lakewood, CON707AZColumbia Asset Trust Corp Trustee · Wichita, KSN707GGLiberty Flight LLC · Goshen, NYN707SWNep Air LLC · Vineland, NJN707TDWhite Plains Enterprise LLC · Kalispell, MTN707THFly Boys LLC · Lincoln, NEN708CPAircraft Guaranty Corp Trustee · Oklahoma City, OKN708CTWilliam Polk Medical LLC · Nashville, TNN708ESWisconsin Aviation Inc · Watertown, WIN708RWBanks Wes J · Oakdale, CAN709ARIantosca Real Estate Inc · Jamaica Plain, MAN709CDTurton Enterprises Co · Wilmington, DEN709FAFlyward LLC · Cockeysville, MDN709KMTuffy LLC · Jacksonville, ORN70BHWls 1000 LLC · Tulsa, OKN70DECirrus Sr22 4452 Inc Trustee · Wilmington, DEN70MWN70mw LLC · Saint Joseph, MON710CDHeidtke Trent · Fountain Hills, AZN710CUNodak Aero LLC · Grand Forks, NDN710KTBradshaw Jeffrey T · Clearwater, FLN710LMValiair Lc Trustee · Casper, WYN710NDLeaning Tree Equipment Mgmt LLC · Jacksonville Beach, FLFirst renewal noticeN710PCCirrusly Aviation LLC · Natchez, MSN710PGOss Auto LLC · Mcallen, TXN711CGOptimal Aircraft Management Nc LLC · Sanford, MIN711FFM S Aviation LLC · Charlotte, NC
Back to AD 2007-24-13