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.
N279RARusso Robert Michael · Pipersville, PAN279RVStewart James L · Garden City, TXN279RWPoe James K · Walterboro, SCN279SVGeorge W Goodknight Inc · Chattanooga, OKN279WYMccarty David · Baker City, ORN279YRegistration Pending · Seneca, SCRegistration pendingN27AHM W T Aviation LLC · Jamestown, NYN27AKLingle Bryan K Sr · Bradenton, FLN27AMThom Jacob D · Wasilla, AKN27AUAndrews University · Berrien Springs, MIN27AZGilbert John K · Austin, TXN27BSl Leasing Group LLC · Barnesville, GAN27BEAir N Nautical LLC · Kalispell, MTN27BGGuzman Steven Manuel · Port Saint Lucie, FLN27BLFairmont State University · Fairmont, WVN27BSBlackhawk 787 LLC · Columbus, OHN27CMM & J Enterprises · Union, SCN27CYSale Reported · Hastings, FLSale reportedN27DASiewruk Cameron M · Stuart, FLN27DHMcavoy Sean M · Greenbrier, TNN27DQOhio University · Albany, OHN27DRN504fl LLC · Killeen, TXN27DWFritschle Derek R · Olney, ILN27EGVetterman Larry D · Hot Springs, SDN27EKPrecision Aviation Training LLC · Newberg, ORN27FCWalburn John M · Mansfield, OHN27GFAmerican Patrols Inc · Midland, TXN27GHNelson Aviation LLC · Chesterfield, MON27GPFlying Colors Airparts Inc · Leesburg, FLN27GSMazzola Michael · Baton Rouge, LAN27GWWatson Gary R · Modesto, CAN27GZKelly Kristofor · Belton, TXN27HALmn Aircraft Leasing LLC · Sellersburg, INN27HBBalk Christopher T · Arlington, WAN27HCCranston Courtland L · Santa Rosa, CAN27HPTrinair Aviation LLC · Hampshire, ILN27HRRemer Herbert I · Punta Gorda, FLN27HTTaylor Arthur W · Oswego, NYN27HUOlson Dorian J · Lake Park, MNN27HWJacobs Jim · Great Barrington, MAN27HYMiand Inc · Laporte, INN27JOliver Paul D · Hedgesville, WVN27JCTalotta Nicholas J · Ocean City, NJN27JPWillis Roger · Bellview, FLN27JWGaither William W · Shallotte, NCN27KHume James W · Valley View, TXN27KKButler Robert Wynne Jr · Boyce, LAN27KPMcgaughey Patrick L · Los Alamos, NMN27LASouthern Aircraft Consultancy Inc Trustee · Casper, WYN27LEQuality Feed Grains · Harrison, AR
Back to AD 2007-04-19 R1