AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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.
N4972KEastern Stearman Inc Trustee · Leesburg, VAN4978CRwr Air Inc · Tok, AKN4978UKempf Rodney G · Eugene, ORN4978YBohannon Donald S · Moreland, GAN4981CWatson Michael · Dalhart, TXN4981KCuriel Gabriel · Oakley, CAN4983UEmerald Coast Entertainment LLC · Lewes, DEFirst renewal noticeN4988Marin Miguel A · QuebecN498TBAdventure Alaska Tours Inc · Hope, AKN4991GAlderman Melvin R · Jacksonville, FLN4994KMenefee Jerry V · Carson City, NVN499KCopper River Airmotive LLC · Copper Center, AKN49AJLvml Real Estate Investments LLC · Rio Grande City, TXN49STHedeen Arnold R · Seattle, WAN4AHHand Kevin D · Anchorage, AKN4ARN4ar LLC · Marienthal, KSN4DXHuffman Aviation & Equipment LLC · Marietta, GAN4LFMacys Flying Service Inc · Tulelake, CAN4UDMorse Donald W · Priest Lake, IDN4VWPronk Glen R · Crittenden, KYN4YYWilliams Scott Griffin · Salt Lake City, UTN4YZLackerdas Harry · Melba, IDN501SFNomarco Inc · Woodburn, ORN50233Garofalo Dawn L · Bellingham, WAN5026VPiland Kenneth Eldon Jr · Carlsbad, CAN5037VPoh Enterprises LLC · Gardena, CAN503ATRegistered aircraftN504JWPalmer Gary H · San Juan, TXN504QChelatna Lake Lodge LLC · Anchorage, AKN505SWBas Part Sales LLC · Greeley, CON506YZR&R Gray Equipment & Cattle LLC · Enid, OKN507DGLynn John Earl Jr · Anchorage, AKN507HHGrossetete Nugget S · Edgewood, NMN5083WJtc Investments LLC · Tyrone, GAN5086ANeeley James L · Temecula, CAN5089C5089c LLC · Fairhope, ALN508TCFisher Travis L · Odessa, TXN50901United Indian Missions Inc DBA · Tucson, AZN5091VWilliams Timothy J · Fernandina Beach, FLN50937Tls Aviation LLC · Eldridge, IAN50939Heart X Aviation LLC · Salmon, IDN50958Stangel Richard C · Enterprise, ORN50CTAyers Jeffrey D · Canandaigua, NYN50DDQualitair LLC Trustee · MichelstadtN50HWMills Charles K · Hernando, FLN50MBCivil Air Patrol Inc · Maxwell Afb, ALN50RHPlane Fun Inc Tr Trustee · Snellville, GAN50SHVitatoe Industries Inc · Chillicothe, OHN5105YMcduff Douglas M · Cook, MNN5106CQuest Aviation Inc · Lake City, FL
Back to AD 2002-07-01