AD 2000-08-13
Registered aircraft · 432
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:2000-08-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:2000-08-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:2000-08-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:2000-08-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.
N515KSCentral Iowa Aviation LLC · Ankeny, IAN515TCCentral Iowa Aviation LLC · Ankeny, IAN51GSGeneral Shale Building Materials Inc · Johnson City, TNN521CHSolomon Mark Trustee · Wilmington, DEN526CFWolff 45 LLC · Ketchum, IDN534NTIvy Brothers Aviation LLC · Gladewater, TXN536MGAcme Aviation LLC · Swansea, ILN537XX945hc LLC · Cypress, TXN545CGGeorge Aviation LLC · Springdale, ARN545XRSoutheast Aviation LLC · Farragut, TNN546DDAlliance Aviation Group LLC · Wilmington, DEN554VAAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN555VRTrego/Dugan Aviation Inc · North Platte, NEN557LMCorsair Two LLC · Hillsboro, ORN557SPU S Bank Na · Marshall, MNN558LMCorsair Two LLC · Hillsboro, ORN558SPUS Bank Na · Marshall, MNN559LMCorsair Two LLC · Hillsboro, ORN567LPLearjet Flyer Inc Trustee · Cheyenne, WYN56JPMed Air LLC · Lawrenceville, GAN56LEAircraft Holding Solutions LLC Trustee · Newark, DEN570AMMann Aviation LLC · Broken Arrow, OKN570MPMed Air LLC · Lawrenceville, GAN577VAAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN57MCMassman Construction Co · Overland Park, KSN57SHSanford Health · Sioux Falls, SDN583PSConquest Express LLC · Libertyville, ILN5861BSignature Air Inc · Canonsburg, PAN589PSInner Harbor 100 LLC · Baltimore, MDN603MYTjm Landair LLC · Omaha, NEN605BXXcel Jet Management Inc · Newark, DEN607BFAlliance Aviation Group LLC · Wilmington, DEN608ADRc30 LLC · Missoula, MTN616KKAmerican Gift Two LLC · Boca Raton, FLN618PJForty Er LLC · Bethany, OKN619RXNine Romeo X-Ray LLC · Southlake, TXN621VSVsa LLC · Clear Lake, IAFirst renewal noticeN623FCMundi Energy LLC · Chula Vista, CAN626JCSeascape Air LLC · Irvine, CAN629BKKeselowski Transportation LLC · Statesville, NCN632JSRms Flight Services LLC · Wilmington, DEN63DZSteel Town Equipment LLC · Exton, PAN63WJKaylan Paige Leasing LLC · Grand Junction, CON645FDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN649JPSeaguard Aviation LLC · Kalispell, MTN64MJM J Electric LLC · Iron Mountain, MIN654ATRbj Industries Inc · Saint Cloud, MNN654DPSix Five Aviation LLC · Austin, TXN657PPPeterson Holding Co · San Leandro, CAN667MCTextile Aviation LLC · Dalton, GA
Back to AD 2000-08-13