AD 2000-25-02 R1
Registered aircraft · 7,563
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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.
N4602EBring Jesse L · Galesburg, NDN4605EAir Dakota Flite · Hettinger, NDN46071Gilt Michael F · Raleigh, NCN4608ECovey Keith L · San Angelo, TXN4609EFinseth Lowell J · Fountain, MNN460ACArizona Skies Aviation LLC · Scottsdale, AZN460LMMassey Larry A · New Braunfels, TXN4610EIllies David P · Fosston, MNN4611DMaki Duane G · Wirt, MNN4613EPangerl Gary D · Mora, MNN461ACTucker Gary · Georgetown, TXFirst renewal noticeN461BGDangelo John A · Dallas, TXN461DMBryn Jamie P · Dazey, NDN4624EDickens David B · Americus, GAN4626EPapen Bruce G · Hardtner, KSN4627ENickels Steve A · Fort Peck, MTN4628ERezabek Richard A · New Meadows, IDN4629ESmith Kevin J · Littlefield, TXN462TAeronca Flyers Inc · Wilmington, DEN4630EBokma Alan S · East Wenatchee, WAN4634EGhafouri Carly · Murrieta, CAN4635EUchimoto Daniel Y · Fayetteville, WVN4642ESeleg Jonathan · Rosebud, MTN4643EScheff David A · Marcell, MNN4646EMeffert Lloyd A · Cotter, ARN464SCCourtney Melissa · Okemos, MIN4652ERalston Roger A · Grand Rapids, MNN4653ERossland David T · Williston, NDN4654EMakely Abraham M · Culpeper, VAN4656GFoss Jared K · Greenbush, MNN4657ENystrom Bay Farm Partnership · Pierre, SDN4658ELund Clayton L · Cheboygan, MIN4659EMichigan Tail Draggers LLC · Macomb, MIN465ACBlue Super D LLC · Clark, NJN4660EKuhn Marwynne G · Hilltop Lakes, TXN4664KWoods Edwin N · Santa Maria, CAN4666EWells Kris G · Barron, WIN4667ESteffen James R · Washta, IAN466DSDrummond Michael S · Lewisville, NCN466SC123 Investments LLC · Clare, MIN4672EKajans Douglas L · Reno, NVN4677EStults Christopher · Wray, CON4678ENorthwind Capital Holdings Inc · Anchorage, AKN4679E3218t Inc · Omaha, NEN467ACFunk Herman L · Stanberry, MON467DFreeman William A · Melbourne, FLN467JJBurch Patricia E · Brookville, INN467KCPrestar Inc · Davis, CAN4680EJohnson Keith M · Creswell, ORN4681EStrahan Ronald R · Girard, KS
Back to AD 2000-25-02 R1