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.
N60CFArq Aviation LLC · Wilmington, NCN60UHSecret Destinations LLC · Gretna, LAN6103YQualitair LLC Trustee · MichelstadtN6105XKramer James W Jr · Eynon, PAN6106CB & S Aviation Enterprises LLC · Atlantic Beach, FLN6107QKk Equipment Leasing LLC · Seguin, TXN610CDChalin Flight Services LLC · Wilmington, DEN611CDPj Aviation LLC · Lake Worth, FLN611CTBrown Jed A · Laredo, TXN611ESGs Flying Club LLC · Bethlehem, PAN611KGProckter Aviation LLC · Lagrangeville, NYN611RMRm Management Corp · Johnson City, TNN611RTGrutza Robert J · Maysville, KYN611VRRex Vinod · Sunnyvale, CAN611WBDelicious Epiphany LLC · Fort Wayne, INN612CTGl One LLC · Ankeny, IAN612EZCsc Delaware Trust Co Trustee · Wilmington, DEN612JMPerformance Aviation LLC · Zionsville, INN612PBFord Alan · Dallas, TXN612WInhoc Capital Holdings LLC · Dallas, TXN612XCSkiventure Holdings LLC · Wayzata, MNN6133PEastwood LLC · Pikeville, KYN613CMcb Consultants LLC · Camden, DEN613MKFlatlands Aviation LLC · Brooklyn, NYN613MMCome Fly With US LLC · Purcellville, VAN614CTailwinds LLC · Warsaw, INN614CY614 Charlie Yankee Lc · Ames, IAN614EATop Joint LLC · Huntingburg, INN614PAPafford Holdings LLC · Ridgeland, MSN614RCMacisaac Richard · Northampton, MAN614RZRasmusson Timothy · Elma, NYN614SRForest Restoration Inc · Philomath, ORN6154WBramlett LLC · Carrollton, TXN615BBBmu22 LLC · Lancaster, OHN615CMA Cirrus Life LLC · Santa Barbara, CAN615EMGinther Associates LLC · Hillsdale, NYN615JPBeyer Munch Enterprises LLC · San Antonio, TXN615LMPerrett Construction Ltd · Valentine, NEN615MBTango Sierra LLC · Kalispell, MTN615PWCardiac LLC · Amarillo, TXN6162CHeller Casey · Williston, NDN6162XCapital Holdings 149 LLC · Kearney, NEN616ASBrozzo Ralph A · Midland, MIN616CWDixie Air LLC · Russell Springs, KYN616JNBatten Aviation LLC · Lancaster, OHN616MB6mb Partners LLC · Burleson, TXN616SPAdmiral Aviation Holdings Lp · Summerville, SCN616YCirrus Design Corp · Duluth, MNN616ZW16 Paws LLC · Navarre, FLN6171ZTennessee Valley Aviation LLC · Fayetteville, TN
Back to AD 2007-24-13