AD 2002-23-19
Registered aircraft · 486
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:2002-23-19')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-19')
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:2002-23-19') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-19') 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.
N860PSLbma Equipment Services Inc · Newburgh, NYN865PKPilot Travel Centers LLC · Knoxville, TNN865WWRegistered aircraftN868SHHca Squared LLC · Nashville, TNN86HDHomerlease Co Inc · Atlanta, GAN870ARFtc Air Holdings LLC · Tampa, FLN870SBSimmons First National Corp · Little Rock, ARN878MMCentury Skies LLC · Englewood, CON87HDHomerlease Co Inc · Atlanta, GAN880PCPromega Corp · Madison, WIFirst renewal noticeN880VJAce Listenger Enterprises LLC · Louisville, KYN881ADDna Air LLC · Wilmington, DEN881CECeoc LLC · Las Vegas, NVN882ADDna Air LLC · Wilmington, DEN883CECeoc LLC · Las Vegas, NVN887CECeoc LLC · Las Vegas, NVN8888Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN888FCBank Of Utah Trustee · Salt Lake City, UTN888NAIdeavillage Products Corp · Wayne, NJN888WLAir Sare One LLC · Delray Beach, FLN889MUGf Aircraft LLC · Tampa, FLN88DDRegistered aircraftN88GDKamali Aviation LLC · Great Neck, NYN890PSLbma Equipment Services Inc · Newburgh, NYN895MMRegistered aircraftN897DWarbler I LLC · Freeland, MIN899BCThabit Holding Co LLC · Sherman Oaks, CAN89PMid-Atlantic Aviation V LLC · Saint Petersburg, FLN89RPRich Aviation Inc · Buffalo, NYN89RTRegistered aircraftN8SBSb Air LLC · Winchester, VAN900EBSubaru Of New England Inc · Norwood, MAN900SETmt Aviation LLC · Wichita Falls, TXN902AMBslcc-III LLC · Renton, WAN902JJetran LLC · Horseshoe Bay, TXN902TFTyson Shared Services Inc · Springdale, ARN904RMAer Sales Lp · Carrollton, TXN905BTvpx Trust Co LLC Trustee · North Salt Lake, UTN909MMNalpak Consulting LLC · Santa Monica, CAN909NFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN90BBBank Of Utah Trustee · Salt Lake City, UTN90MCAirex 3 LLC · Romulus, MIN9147HLenox Aviation II LLC · Lawrenceville, NJN914LDSdl Management Company LLC · Santa Ana, CAN914MCMountaire Corp · Little Rock, ARN915FGFgf Sovereign LLC · Dallas, TXN915LGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN918MJRegistered aircraftN919CHLeipold Aircraft LLC · Racine, WIN920CERmhco LLC · Denver, CO
Back to AD 2002-23-19