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.
N2623PJd Aero LLC · Chester, SDN26240Gilmer Thomas · Deridder, LAN26244Clear Blue Aviation LLC · Melbourne, FLN26247Royer Virgil P · Salem, ORN2624AWsiaki Kenneth J · Northridge, CAN2624GVietnam Helicopters · Concord, CAN2624NBoston Helicopters Inc · North Andover, MAN2624PRobinson Eric C · Palmer, AKN2624QKalarney Kerry T · Olathe, CON2624WWilkins James K · Owens Cross Roads, ALN2624XBritton Daniel W · Fairbanks, AKN2624YWarner James R · Van Alstyne, TXN26253Tompkins Robert G · Panacea, FLN26255Wren Donald F · West Chester, OHN2625CL&W Leasing LLC · Murfreesboro, TNN2625MB-Hive Inc · Augusta, GAN2625QSutton Aircraft Salvage LLC · Palmer, AKN2625SSierra Aviation LLC · Plaza, NDN2625WPatton William D · Sheridan, WYN26264Edb Air Inc · Wilsonville, ORN2626BRodgers Patti · Apple Valley, CAN2626FJohnson James E · Stevensville, MTN2626KUpwind Floats LLC · Seattle, WAN2626PLeguia Augusto A · Kathleen, GAN2626QTomasini William M · Boring, ORN2626R2626r LLC · Tucson, AZN2626SDelta Aero LLC · Sarasota, FLN26273Gasiorowski Mark A · Buford, GAN26278Bal-Air LLC · Boca Raton, FLN2627CC And T Aviation LLC · Shreveport, LAN2627FUlrich Robert W DBA · Twisp, WAN2627MN2627m LLC · Rehoboth Beach, DEN2627NCartwright Josh D · Salem, MON2627RTaylor John B · Norwich, OHN2627WDiamond Engineering & Service Co · Granger, INN2628FPlata Darryl · Arlington, WAN2628GArsenault Donald S · Round Rock, TXN2628PCraig Richard L · Sonoma, CAN2628QSannikova Olga · Sherman Oaks, CAN2628ZSipes Gary C · Livingston, TXN26292Qualitair LLC Trustee · MichelstadtN26294Dennen Corey M · Troup, TXN26297Hunter Danny L · Gulfport, MSN26298Champaign Sharon E · New Holstein, WIN26299Ferraris Robert · Tinton Falls, NJN2629FFodness Jan N · Sioux Falls, SDN2629QStallings Floyd P · Vine Grove, KYN2629WHogan James C DBA · Cameron Park, CAN262ACLavelle Jeffrey · Kenmore, WAN262AFState Of Louisiana · Baton Rouge, LA
Back to AD 2007-04-19 R1