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.
N442KYSouthern Cubs LLC · Jupiter, FLN442LCKnudtson Kirk · Kasson, MNN442LHSkylane 182q LLC · Punta Gorda, FLN442MDMagill Zane · Castell, TXN442MLOrlowski Micheal A · Gold Hill, NCN442MRSleigh Helicopter LLC · Palm City, FLN442PABird Acquisition LLC · Phoenix, AZN442PDDesoto Parish Sheriff Office · Mansfield, LAN442PMBusby James D II · Port Saint Lucie, FLN442PPWilco Helicopters Inc · Oregon, ILN442PTAutodealersonly.Com Inc · Brunswick, GAN442PWBeluga LLC · Wasilla, AKN442RAKing Air Properties LLC · Huntington Beach, CAN442RDThompson Helicopters LLC · Uvalde, TXN442RGRivas Andrew · Flagstaff, AZN442RJHeymach Robert F · Holbrook, NYN442RMRocky Mountain College · Billings, MTN442RNPope Jim D · Lewiston, IDN442RTRm Capital Holdings LLC · Hockessin, DEN442RWRobertson David · Cullman, ALN442RYParagon Helicopter Services LLC · Claremore, OKN442SGriffing Flying Service Inc · Port Clinton, OHN442SAG & M Aircraft Inc · Wheat Ridge, CON442SDTeam Negrich LLC · Osteen, FLN442SHRudd Wayne G · Basalt, CON442SSN442ss LLC · Middletown, OHN442TFerreira James M · Dixon, CAN442TCCrawford Thomas A · Hawthorne, FLN442THUtah State University · Logan, UTN442TSLehman Aviation LLC · Winamac, INN442TTQualitair LLC Trustee · MichelstadtN442TWMclaws Craig J · Sheridan, WYN442VBHicks Seal Coating & Striping LLC · Bell, FLN442WBAllen Lanny D · Indianapolis, INFirst renewal noticeN442WMElkhorn Aviation Inc DBA · Baker City, ORN442WRWhite Ryan R · Polk City, IAN44308Hanson Garrett G · Snohomish, WAN44309Urstadt Chris M · Girdwood, AKN4430KLivingston Peter J · Ventura, CAN4430RDunder Neil DBA · Cicero, INN4430ULfm Aviation LLC · Bozeman, MTN4430WMagerit Aviation Inc · South Boston, MAN4430YEvergreen Soaring Inc · Lynnwood, WAN44314Yates Cecil R · Westminster, CAN44318Trinity Air Service Inc · Klamath Falls, ORN4431AResetarits Matthew · West Seneca, NYN4431QGraham Huber L · Gulf Breeze, FLN4431RRaritan Valley Flying School · Princeton, NJN4431TTaylor Timothy · Chandler, INN4431WUnited Roofing Of Central Florida Inc · Ocala, FL
Back to AD 2007-04-19 R1