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.
N34AXPw58 LLC · Dover, DEN34BMaresco International Corp · Alpha, NJN34BAPrvny Pluk LLC · Houston, TXN34BBMcvay Larry A · Boise, IDN34BLAmerican Asset Leasing LLC · Aurora, ORN34BPAviation Insurance Managers Inc · Uniontown, OHN34BQBettendorf Nicholas L · Mchenry, ILN34BRIndustrial Reports Inc · Raleigh, NCN34BTWilliams Charles R · Wadsworth, OHN34BVDessuit Franklin Jr · Mckinney, TXN34BWMaintenance Forecasters Inc · Falmouth, MIN34BZDimich Milan C · Madison, SDN34C34 Charlie LLC · Helena, MTN34CBCyrier John P · Lockhart, TXN34CDCannon David A · Magnolia, TXN34CFPayne James Michael · Twin Falls, IDN34CQRocky Mountain Warbirds LLC · Kalispell, MTN34CRRounds Donald C DBA · Waller, TXN34CURegistered aircraftN34CWRegistered aircraftN34CXSchwerman Carl J · Oconomowoc, WIN34CZN34cz LLC · Port Saint Lucie, FLN34DAGlover William S · Mount Pleasant, TXN34DBRegistered aircraftN34DEStephens Justin R · Gatesville, TXN34DKTennessee Aviation Services LLC · Sevierville, TNN34DLAdlava LLC · Dover, OHN34DMGlotfelty John E · Durango, CON34DNThomas Daniel Craig · Shady Shores, TXN34DTSutton William E · Salinas, CAN34DVNelson Neil Wayne · Corvallis, ORN34DWDarvis Enterprises LLC · Addison, TXN34DYMccormick Daniel · Salem, SCN34EECodingflyboy LLC · Hayward, CAN34EMSpirit Rotorcraft LLC · Phoenix, AZN34ESTough Old Bird Aviation LLC · Beavercreek, OHN34EVSilva Alexander J · Holly Springs, NCN34EXWilliams Dock G · Carmel Valley, CAN34FCN34fc LLC · Boise, IDN34FFZwierlein Victor · Grand Prairie, TXN34FGState Of Alaska · Fairbanks, AKN34FHJeffcoat Jon T · Nome, TXN34FUWatson George E · Temecula, CAN34FXPietig Jacob T · Santa Cruz, CAN34GCPhillips Stuart G · Woodside, CAN34GHRoofing Guys LLC · Marion, ILN34GRSeton Bruce B Jr · Port Townsend, WAN34GSGhavi Enterprises Inc · Kenosha, WIN34GTKawolis Paul F · Sutton, MAN34HCSummit Concepts Inc · Wilmington, DE
Back to AD 2007-04-19 R1