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.
N3703YWilemon Ronald J · Tulsa, OKN3704ACousin Sydney Louis Jr · Renton, WAN3704GGap Holdings LLC · Dover, DEN3704MLacroix Robert Emile Jr · Orlando, FLN3704PAlderman Mark C · Wasilla, AKN3704QRipley Robert G · Griffin, GAN3704TStevens Michael J · Punta Gorda, FLN3704ZGray Melinda G · Milan, ILN37050F33a Partners LLC · Holderness, NHN3705FMonteith Andrew W · Lebanon, PAN3705QCourts Data Center Consulting LLC · Lakeway, TXN3705TN3705t LLC · Dallas, TXN3705YMunoz Concepcion · Tulsa, OKN3706KRegistration Pending · Cedar City, UTRegistration pendingN3706NJsn Aviation LLC · Huntersville, NCN3706QSteed George W III · Silverdale, WAN3706TFinished Work Aviation LLC · Redding, CAN3706UBrownfield Ken F · Boonville, MON3706YAlexander Steve Craig · Shreveport, LAN3706ZHall John L · Port Angeles, WAN3707AMorris Charles W · Wasilla, AKFirst renewal noticeN3707DWilliams Charles S · Pearland, TXN3707PHamm Russell K · Owasso, OKN3707QTroutman Shaun · Johnson, KSN3707TFisher Kurt A · San Luis Obispo, CAN3708AFreyburger Paul W · Java Village, NYN3708KWard Ron · Oklahoma City, OKN3708PAeromarine Consulting Inc · Brandon, FLN3708UCollins George H · Murfreesboro, TNN3708XHammon Justin M · Colorado City, AZN3708ZReisman Richard H · Montrose, CON37091Lee James P · Madisonville, TNN3709DAbidance Inc · Winthrop, WAN3709NShow Me The Mooney LLC · Hartford, KYN3709TJudice Eric M · Elgin, ILFirst renewal noticeN3709UMoser Scott M · Pisgah Forest, NCN370ACNuza Philip A · Sidney, MEN370AJCoyne Patrick J · Tuam Co CalwayNon-citizen corporation, flight hours not reportedN370BBBuffalo Biodiesel Inc · Tonawanda, NYN370BFDaal Inc · Wilmington, DEN370BLWingsleasing LLC · Wichita, KSN370CPCivil Air Patrol · Maxwell Afb, ALN370DLLee David · Skaneateles, NYN370FLFingerlakes Wing And Rotor LLC · Seneca Falls, NYN370GAir Land Ventures LLC · Highland Park, ILN370HMHoneybee Helicopters LLC · Kalispell, MTN370JCSouth Oaks Inc · Hollywood, FLN370JGGuideair LLC · Eden Prairie, MNN370JHNational Aircraft Leasing Corp · Greenville, DEN370K370k LLC · Bethany, OK
Back to AD 2007-04-19 R1