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.
N31600Florida 7771 Aviation Assets LLC · Lakeland, FLN31602Sutton Aircraft Salvage LLC · Palmer, AKN31608Hall Larry Brent Jr · Charlottesville, VAN31609Kbb Aviation LLC · Prairie Grove, ARN3160LKo Hee Sun · Norwood, NJN3160STronier Paul C · Sparks, NVN3160WPalmetto Wings LLC · Longs, SCN31617Valiair Limited Co Trustee · Casper, WYN3161CFinzer Melvern K · Naperville, ILN3161PEga Aero Specialty Services LLC · Beaufort, SCN3161RDeertrack Aviation LLC · Oshkosh, WIN3161SKrikorian John R · Fresno, CAN3161WPritchard Casey M · Bells, TXN3161YSleepy Cat Mountain Real Estate Co · Meeker, CON3161ZTyner James A · Bend, ORN3162DMarks Daniel A · Portersville, PAN3162FSkinner Roma L · Ovilla, TXN3162LG&M Aircraft · Wheat Ridge, CON3162RSky West Aviation Inc Trustee · Albuquerque, NMN3162SEagle Aircraft LLC · Park City, UTN3162USchreiber Charles R · Calexico, CAN3162YRogers Anthony L · Monrovia, CAN31630Harris Jeffrey M · Crossville, TNN31632Mikerich LLC · Laguna Hills, CAN31634Ahmed Sharfaraz · Houston, TXN31636Terwilliger Michael P · Groveland, CAN3163FSchwab Roscoe C III · De Kalb, TXN3163SLabrum Andrew K · Boise, IDN3163VZak Enterprises LLC · Cortez, CON3163WSkye Peak Corp · Greenfield, MAN31641Ruefer Fred · Muskogee, OKN31642Gr8 Sky Aviation LLC · Calhoun, GAN31644Aquarius Aviation Inc · Miami, FLN31649Runway Hero LLC · Wayland, MAN3164DCallahan Robert D · Mesa, AZN3164QHanson Donald R Jr · Hillsboro, NDN3164TOverflight LLC · Harahan, LAN31657Wynne Kenneth H · Branford, CTN3165EJlk Management LLC · Kerrville, TXN3165FFindlay Bruce · Caro, MIN3165LToll Harry V · Tucson, AZN3165PNordstrand Steven D · Oak Harbor, WAN3165QNorris Benjamin · Zolfo Springs, FLN3165RReds Cable Tv Inc · Washington, NCN3165UMetz Martin A · Phoenix, AZN3165YFoster John W · Olathe, KSN3165ZSmith Kenneth W · Bedford, INN31661Mosley Ken · Westlake Village, CAN31669Navy Annapolis Flight Center Inc · Edgewater, MDN3166CPersinger Paul W · Wasilla, AK
Back to AD 2007-04-19 R1