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.
N5268BCabbage David A · Colville, WAN5268HGrander Aviation LLC · Panama City Beach, FLN5268JReach For Skies LLC · San Antonio, TXN5268KSorbi Aviation Inc · El Cajon, CAN5268RJohnson Steven D · Oklahoma City, OKN5268TDykes Don A · Houston, TXN52694Sullivan Michael E Trustee · Granite Bay, CAN52698Marshall Gregory · Farmington, MEN5269ERocky Pointe Logistics LLC · Hayden, IDN5269GBrachtenbach Eric · Hill City, KSN5269LKarel John · Stillwater, MNN5269NHigh Maintenance Inc · San Luis Obispo, CAN5269SCanyon Blue LLC · Sharpsburg, GAN5269TKailua Aviation LLC · Moorestown, NJN5269WGoetz David B · Gleason, WIN5269YFlying K Aviation LLC · Quinlan, TXN526AAPeregrine Howard Partners II Lp · New Orleans, LAN526APAtlas Casters LLC · Ashland, ORN526BLWarren Flying Club Inc · Troy, MIN526CHSky West Aviation Inc Trustee · Albuquerque, NMN526CNJensen Michael S · Plano, TXN526DCDrummond Aviation LLC · Wichita, KSN526DPAllaire Ernest · Groton, CTN526ECChapman Daniel W · Soldotna, AKN526EPEpic Aviation Inc · Denison, TXN526ERLong Island Aviators LLC · Seaford, NYN526FRoush Heith · Cabot, ARN526GCareer Pilot Training LLC · Wilmington, DEN526HBBarri Michael J · Burgaw, NCN526JSStephan Dwight M · Center Moriches, NYN526KGWalters David M · Wasilla, AKN526LDe Witt Luba Trustee · Fort Lauderdale, FLN526LKKenzy 2022 LLC · Castle Rock, CON526LPAugustine Alan Aviation LLC · Aberdeen, NCN526LTCheatum Roger K · Port Orange, FLN526LWN526lw LLC · Salem, ORN526MABlue Sky Adventures LLC · Hanover, PAN526MMInfante Juan Carlos Jr · Palmetto Bay, FLN526MPS Brown Inc · Durant, OKN526NDSpartan Education LLC · Tulsa, OKN526PDDecraene Peter R · Shorewood, ILN526PLEdson Aviation Group LLC · Jericho, VTN526PMMccandless Malinda Sue · Sussex NbFirst renewal noticeN526RJN526rj LLC · Sulphur, OKN526RVDeweese Alton R Jr · Dothan, ALN526SCorvo Alberto · New York, NYN526SCFrick Richard T · Nekoma, KSN526TRYankee Helicopters LLC · Plainville, CTN526UJsrs Holdings LLC · Las Cruces, NMN526VBGilbert Benjamin N Trustee · Chico, CA
Back to AD 2007-04-19 R1