AD 2001-07-11
Registered aircraft · 472
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:2001-07-11')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-07-11')
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:2001-07-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-07-11') 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.
N17AValiair Limited Co Trustee · Casper, WYN17AHSpirit Wing Aviation Ltd · Guthrie, OKN17AZSkylink Jets Inc · Fort Lauderdale, FLN17GJGlobal Jetcare Inc · Brooksville, FLN181EFAloft Aviation Services LLC · Spartanburg, SCN18EVE D Santos & Associates LLC Trustee · Wilmington, DEN18FNGh Equipment LLC · Dover, DEN18RARoyal Air Freight Inc · Waterford, MIN1926SHigh Performance Aircraft LLC · El Cajon, CAN1932KSpeed Aviation Holdings LLC · Lewes, DEN193DBDakota Territory Air Museum · Minot, NDN1965LMuseum Of Flight Foundation · Seattle, WAN1DEChampion Air LLC · Mooresville, NCN1TWNasa 805 LLC · Whitefish, MTRegistration expired, pending cancellationN1VGE D Santos & Associates LLC Trustee · Wilmington, DEN200KBRainier Jets LLC · Middletown, DEN200YClassic Lear Jet Foundation · Wichita, KSN202LJE D Santos & Associates LLC Trustee · Wilmington, DEN203VSCalspan Corp · Buffalo, NYN204RTCalifornia Motorsports Group Inc · San Diego, CAN20CRWestern Air International Corp · Fort Lauderdale, FLN20GJGlobal Jetcare Inc · Brooksville, FLN20XPVenture Jets LLC · Lititz, PAN211GSInternational Air Services Inc Trustee · Carson City, NVN217CKKalitta Charters LLC · Ypsilanti, MIN217TAFox Aviation LLC · Santa Maria, CAN218NBDavid L Samani Md Inc · Lincoln, NEN21VNC2d LLC · Wilmington, DEN220CKKalitta Charters LLC · Ypsilanti, MIN229LJN229lj LLC · Bentonville, ARN235LJMango Aviation Parts LLC · Plantation, FLN237CKKalitta Charters LLC · Ypsilanti, MIN237TWTechnical Education Services Inc DBA · Virginia Beach, VAN238AXFabio Lopez · Denver, NCN239AYCavalljet Corp · The Woodlands, TXN239CASantiago Communities Inc · Orange, CAN239JCIbikunle Christopher · Dover, DEN23BYYounkin Matthew A · Siloam Springs, ARN240BThunderun Aviation Corp · Glenwood, NYN243JRDodson International Parts Inc · Rantoul, KSFirst renewal noticeN244LJN244lj Aviation Inc · Middletown, DEN244RG369ba LLC · West Columbia, SCN249HPSale Reported · Camden, DESale reportedN24NNWorld Jet Of Delaware Inc · Fort Lauderdale, FLN24SAviation Sales And Charter LLC · Dover, DEN24SAClark Lloyd E · Hanover, MDN24WXTre Aviation Corp · Wilmington, DEN251TSLopez Fabio A · Denver, NCN255LVN255rv Aviation Corp Inc · Middletown, DEN255RVSolomon Mark Trustee · Wilmington, DE
Back to AD 2001-07-11