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.
N33ERCrump Edward J · Boonton, NJN33ESDuncan Ernest Michael · Dripping Springs, TXN33EYYoung Robert E · Princeton, NCN33FCReece Trucking And Excavating Inc · Marysville, WAN33FKMotis Joseph D · Huntington Beach, CAN33FMAtp Aircraft 7 LLC · Wilmington, DEN33FSBvd Inc · Yates Center, KSN33FUZeiset Karl D · Salmon, IDN33FXDougfly Inc · Malibu, CAN33GCMarble Jere D · Dayton, NVN33GJOliser Andras · Savannah, GAN33GKDugger Glenn · Denton, TXN33GLJohnston Jeremy A · Cedar Springs, MIN33GRHeadrick John Eric · Eolia, MON33GVMilhous Richard J · Aguila, AZN33GXSiman-Tov Yariv · Redmond, WAN33HParker Shon T · San Angelo, TXN33HARykris Investments LLC · Bowling Green, KYN33HCSmith Christopher J · Longwood, FLN33HLKnudsen Russell G · East Troy, WIN33HMSands Daniel N · Los Lunas, NMN33HNPalmer Airmotive Inc · Lockport, NYN33HPHale William L · Loveland, CON33HRHarpole Mark J · Sisters, ORN33HSN33hs LLC · Tallahassee, FLN33HTGroove LLC · Afton, VAN33HURunzel Brothers Aviation LLC · Bensenville, ILN33HYKiger Lance · Prairieville, LAN33JSaunders Dwayne E · Cary, NCN33JBKitchel Jeffrey V · Phoenix, AZN33JCMurphree Matthew · San Marcos, TXN33JDRiggs Alan Vance · Artesia, NMN33JFKimsey Thomas Wayne · Warner Robins, GAN33JHRoelfs Vernon L · Eagle River, AKFirst renewal noticeN33JJFincor Inc · Miami Beach, FLN33JKMidway Aviation Co · Plant City, FLN33JLJ L Flyers LLC · Orinda, CAN33JMKingdom Air Corps · Sutton, AKN33JSBroughton Corp · Newtown Square, PAN33JXProuty Timothy V Trustee · North Providence, RIN33KMathison John Michael · Fernley, NVN33KJPlane Fun Inc · Bow, WAN33KKMcguiness Construction Inc · Ramona, CAN33KRAviaschin LLC · Frisco, TXN33KSMeggers Roger D · Baker, MTN33LAOscar Tango LLC · Mesa, AZN33LFJbo Airventures LLC · Saint Petersburg, FLN33LHKeller Charles T · Thaxton, MSN33LPA&H Services LLC · Danville, GAN33LTKelly Tony R · Aberdeen, MS
Back to AD 2007-04-19 R1