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.
N6005CWings And Wedges LLC · Fort Lupton, CON6005LPeairs Gregory Ross · Sacramento, CAN600BZCirrus Design Corp · Duluth, MNN600KG600kg LLC · Middletown, DEN600KTAtaraxia Aircraft Holdings LLC · Greenville, SCN600LBSas Cirrus Vannes Inc Trustee · Cheyenne, WYN600SKMorin Aviation LLC · Accident, MDN6012BQualitair LLC · MichelstadtN6013UGideon Aero LLC · Dayton, OHN6019QNeufeld Wilhelm Loewen · Presidio, TXN6019ZRankin James L · Carmel, INN6026KCirrus Dreams LLC · Southbury, CTN602CGTanton Aero LLC · Lewes, DEN602SASouthern Aircraft Consultancy Inc Trustee · Casper, WYN602UKSr22 Fliers LLC · Lake Sherwood, CAN6030BBradley Jacob · Poulsbo, WAN6036QValiair Limted Co Trustee · Casper, WYN603CPRedd Aviation LLC · Spanish Fork, UTN603DJN603dj LLC · Rye, NHN603DPSky West Aviation Inc Trustee · Albuequerque, NMN603EFElite Aviation Group LLC · Wall Township, NJN603MHPlane Company LLC · Greenbrier, TNN603SRBut Cirrusly LLC · Wilmington, DEN603WWRsh Whiskey LLC · Thornville, OHN6043G4031 Aviation Inc · Bemidji, MNN60454Valiair Lc Trustee · Casper, WYN604HBDownhour Aviation LLC · Benton, LAN604WMPrivate Aviators LLC · Loretto, MNN6051CQualitair LLC Trustee · MichelstadtN6053UAtlas Vineyard Management Inc · Napa, CAN605CDFl175 Aviation Partners LLC · Sugar Land, TXN605LMBst Cirrus LLC · Mooresville, NCN605MHSteinberg Kenneth R · Longport, NJN605RMClear Prop Aviation LLC · Palo Alto, CAN606CTPkck Plane LLC · Newton, MAN606KHWood & Wood Aviation LLC · Boaz, ALN606MFAtaraxia Aircraft Holdings LLC · Greenville, SCN6071BRoss Bryan L · Marion, MSN607ARCirrus Design Corp · Duluth, MNN607PCCidale David R · Grand Island, NYN608AEFreedom Aviation LLC · Weatherford, TXN608CDHorizon Ventures Inc · Fayetteville, ARN608SRMachugh Cliffton D · Albany, ORN6099ZN6099z Inc Trustee · Wilmington, DEN609AEGundersen Erik · Chino Hills, CAN609CThorson Gregory · Mequon, WIN609CDCavu Aviation LLC · Huntsville, ALN609DWith Pride Aviation LLC · Farmingdale, NYN609KGGeiger Aviation LLC · Wilmington, DEFirst renewal noticeN609MRScudder Aviation LLC · Enid, OK
Back to AD 2007-24-13