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.
N33CFObx Boil Aviation LLC · Kitty Hawk, NCN33HCSmith Christopher J · Longwood, FLN33JGCavu 1989 LLC · New Hope, PAN33MWSackett Gary G · Millcreek, UTN33PFNeed For Speed Aviation LLC · Charleston, SCN33TVTgbde LLC · Fort Pierce, FLN33WSJak2 Properties LLC · Ocala, FLN340CDArgent Holding (USA) Ltd · Corona, CAN341EYEdy Aviation LLC · Framingham, MAN3427BBoyle Corey J · Robbinsville, NJN3427DPowers Ryan · Boston, MAN342ACC & L Aviation LLC · Swainsboro, GAN342CDBlanchard Aviation LLC · Waynesboro, GAN342GFKites Rising LLC · Naples, FLFirst renewal noticeN342SRRh Air LLC · Slinger, WIN342TTLewis Charles Ryan · Napa, CAN343BPShelton Joseph H · Fort Worth, TXN343CDMastin Air LLC · Dover, DEFirst renewal noticeN343STJagc LLC · Freeport, FLN3442TBoyle Ventures LLC · Rogers, ARN344ARpm Aviation LLC · San Antonio, TXN344CDAircraft Guaranty Corp Trustee · Oklahoma City, OKN344SKDriver Aviation LLC · Bloomfield Hills, MIN345DAGrigg Apiaries Inc · Hot Springs, MTN345ETKeene Warren · Post Falls, IDN345JREastern Stearman Inc Trustee · Leesburg, VAN345TSUncle Bob Consulting LLC · Antioch, ILN345WZEntroair LLC · Hilliard, OHN347CDCulkin Daniel J Trustee · Edmond, OKN347CPNwr Aviation LLC · Scottsdale, AZN347EPEauclaire Aircrafts LLC · Weston, MAN347SRVenture North Aviation LLC · Cloquet, MNN348CD348 Charlie Delta LLC · Ames, IAN348SBVector Victor Aviation LLC · Geneva, ILN348TSTuchman Holdings LLC · Englewood, NJN34CDCannon David A · Magnolia, TXN34TGTri W Inc · Shepherd, MTN34WGWings Of Grace Inc · Vonore, TNN351SREagle I LLC · Kalispell, MTN352KPN258wt LLC · Boca Raton, FLN352MMWindmill Aviation LLC · Sleepy Hollow, NYN352MRN352mr LLC · Weldona, CON352RCN352rc Inc Trustee · Wilmington, DEN352SRGulf Atlantic Airways Inc · Gainesville, FLN353CDSt Croix Leasing LLC · Fredonia, WIN353KSReichard Leasing LLC · Harrisburg, PAN353PGDecarlo Rick P · Minden, NVN354EMSrm Aviation Solutions LLC · Richland, WAN354FCBlue Sky November LLC · Mamaroneck, NYN355GKAircraft Holding And Leasing LLC · Sarasota, FL
Back to AD 2007-24-13