AD 2007-04-19 R1
Registered aircraft · 108,434
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-04-19-R1')
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-04-19-R1')
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-04-19-R1') 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-04-19-R1') 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.
N4740EVehorn Richard B · Carrollton, TXN4740FSkydive Ricks LLC · Petersburg, OHN4740NGtz No 1 LLC · Kalispell, MTN4740QFitzpatrick D L III · Whitefish, MTN4740RCall Tracy J · Carmel Valley, CAN4740SJeg Air LLC · Monroe, GAN4740WCagle John · Lubbock, TXN4741KCrosswind Solutions Inc · Medford, ORN4741LMallard Scott R · Capshaw, ALN4741NCimmaron Flying Inc · Colorado Springs, CON4741SOkkb2 Inc · Vancouver, WAN4741XRessel Erik P · Lakewood, CON4742Sale Reported · Guymon, OKSale reportedN47423Synergy Wellness Group Inc · Bakersfield, CAN47426Lockhart Flying Club · Lockhart, TXN47428Nei Jeffrey G · Bemidji, MNN4742LGautier Thomas · Cleveland, OHN4742NRegistration Pending · Wilmington, DERegistration pendingN4742UProtocol Enterprises LLC · Holdrege, NEN47431Thornley Kyle A · Allen Park, MIN47438Mielens Jeremy · Chelmsford, MAN4743BAmstrup Norm D · North Pole, AKN4743CFour Three Charlie LLC · Andover, MAN4743DEss Partnership LLC · Waterford, MIN4743ERegistered aircraftN4743LRegistered aircraftN4743MMcbride Paul · Dallas, TXN4743NGallagher Jeff · Rio Oso, CAN4743QHabersetzer Brian D · Brush Prairie, WAN4743SDimitri Bevc · Pleasanton, CAN4743XAerotech Mapping Inc · Las Vegas, NVN4744CDesert Aviation LLC · Kingman, AZN4744GJackson Flight Center LLC · Moses Lake, WAN4744K4744k LLC · Mesa, AZN4744LSeniura Jerry W · Millington, MIN4744TKolp Mark H · Andrews, TXFirst renewal noticeN4744VSettle David A · Lyons, KSN47452Cherry Hill Aviation Inc · Freetown, INN4745DRoman Steven T · Burgettstown, PAN4745LFlying Ts LLC · Royal Oak, MDN4745NHowze William Scott · Robstown, TXN4745VFiecke Rodney J · Cokato, MNN47463Ales Victoria LLC · Elburn, ILN4746LJrc Aviation Inc · Plano, TXN4746NDenham Stacy L · Chehalis, WAN4746RZurawski Joseph · Ocala, FLN4746U4746u LLC · Sherman Oaks, CAN47473Tsk Aviation LLC · Paducah, KYN4747ADouthitt Mike L · Butte, MTN4747CAlfred Joseph T · Pagosa Springs, CO
Back to AD 2007-04-19 R1