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.
N522SRDias Antonio M · Scottsdale, AZN522VCommodore Aviation LLC · Danville, ALN522WMJaybirds Aviation LLC · Saint Cloud, MNN522WTTme Cirrus LLC · Virginia Beach, VAN523CMMelrose Law Pllc · Waynesville, NCN523GWA And P Farms LLC · Wilmington, DEN523RKCirrus Design Corp · Duluth, MNN523RSN523rs LLC · Middletown, DEN524CCAubuchon Scott M · Fenton, MIN524DACpi Management Group LLC · Las Vegas, NVN524ETWanderair LLC · Maple Grove, MNN524PEN524pe LLC · Brookshire, TXN524SRWaypoint Holdings LLC · Greensboro, GAN525BECya Aviation LLC · Saint Marys, WVN525ECJohn Papa Zulu LLC · Hauppauge, NYN525PCJcp Logistics LLC · Little Rock, ARN525SRSchnitker Air LLC · Kalispell, MTN5261WHodge Nicholas C · Spokane, WAN526CAM & M Aviation LLC · Pompano Beach, FLN526HDTensor Air LLC · Atlanta, GAN526SCorvo Alberto · New York, NYN526SRBarrow James E Jr · Keysville, GAN526TSN526ts LLC · Lake Charles, LAN527AGBroken Road Aviation LLC · Kerrville, TXN527CDAircraft Medical Solution LLC · Kissimmee, FLN527CPBimski Holdings LLC · Orem, UTN527CRJoe Wagner IV Construction LLC · Zebulon, NCN527JKBeckair LLC · Ankeny, IAN527TRDawson Kevin · Colorado Springs, CON527WWAirtime Flying Club LLC · Richmond, VAN528BJN528bj LLC · Sandyville, WVN528CAWile Frederick A · Meridian, MSN528DBRegistered aircraftN528DLLlt LLC · Middleton, WIN528HEKingdom Airworks LLC · Las Vegas, NVN528MOcala Gator Aviation LLC · Ocala, FLN528PCWhere 2 LLC · Las Vegas, NVN528PFEarspasm LLC · Brooklyn, NYN528SMSpeedishtong Aviation LLC · Deer Park, ILN528SRAaa Flying Club Inc · Fort Wayne, INN529AJCaiazzo Leonard · Belle Harbor, NYN529BKFlying Offices LLC · Princeton, MAN529BLLevair LLC · Edmond, OKN529CDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN529MKBlue Ryan LLC · Englewood, CON529PVVlahos Aviation LLC · Destin, FLN529SRGreaney White & Associates Inc · Valley, ALN52DGVero Beach Aviation LLC · Vero Beach, FLN52PJJensen Paul · Highland Village, TXN52SAByrd Aircraft Solutions LLC · Dothan, AL
Back to AD 2007-24-13