AD 74-18-13
Registered aircraft · 1,642
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:74-18-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:74-18-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:74-18-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:74-18-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.
N56866Skelton David W · Baker, FLN56934Low Allen R · San Francisco, CAN574PRSoto Angel L · Las Piedras, PRN574TMJohnson Tristan O · Pensacola, FLN589VWPierce Thurlow L · Attica, MIN596TCWinyah Aviation LLC · Wilmington, DEN5986VLampin Aviation LLC · Brielle, NJN59SWLg Services LLC · Chino, CAN5MHGould Ralph Harvey Jr · White Cloud, MIN5YPMo'S Ventures LLC · Lakeside, CAN600JGWiltcher Christopher Alex · Gallatin, TNN600JLMinisterio Internacional Gracia Y Poder Inc · Houston, TXN6051HFlying Six Inc · Mc Cool Junction, NEN6073HHall Aviation Inc · Phenix City, ALN60LYLeon Roberts Enterprises LLC · Vienna, VAN60PLPapa Lima LLC · York, NEN60TTOurhappyfamilyplane LLC · Mason, OHN610MAThomas Michael J · Malabar, FLN612JSWings Of Eagle LLC · Leo, INN616JPWb Painting Contractors LLC · Greenville, MSN617ETBunck Richard DBA · Apple Valley, CAN6198JBess Michael S · Niceville, FLN61DEBergabo Bjorn E · Norwalk, CTN620BCBlair Bob Jr · Essex, MON621TGSchmotzer Donald S · Ladson, SCN6228JRegistration Pending · Fort Myers, FLRegistration pendingN625PBForward Aviation LLC · Statesville, NCN626RNFerguson & Son Inc · Lebanon, TNN629FCDoherty Paul A · Van Buren, ARN62DJZig Zag Inc · Wilmington, DEN6300MShortfin Holdings LLC · Seneca, SCN6300YSullivan Mark F · Cocoa Beach, FLFirst renewal noticeN63146C M B Aviation LLC · Farmington Hills, MIN631BWHaase Eric J · Woodland Hills, CAN6326CBridges Gerald Lloyd · Chelsea, MIN632WBKesner Ronald H Jr · Troy, VAN633SGCherokee N633sg LLC · Leonardtown, MDN636EBPoint To Point Air LLC · Arlington, WAN6409CCrider Richard S · Prescott, AZN645BCNolan Kevin J · North Bend, ORN645CHWebster Jason M · Orlando, FLN646SDBiton Liad · San Diego, CAN647BMaxiao Aviation Corp · Milpitas, CAN649BCFlyport LLC · Crossville, TNN64CTFly2dig LLC · Laclede, IDN64EHRed Stick Brothers LLC · Baton Rouge, LAN64EWLapp Philip D · Weatherford, TXN64USJc Investors Group LLC · Coral Springs, FLN64WCTrahan Stewart K · Little Rock, ARN65194Vliegen LLC · Urbandale, IA
Back to AD 74-18-13